Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
how to import 434 mb mysql database
Old 01-25-2010, 07:45 PM how to import 434 mb mysql database
Experienced Talker

Posts: 49
Trades: 0
trying to do it,

can;t do it in phpmyadmin

trying to do it in shell using

mysql -u dime_succexss -p dime_succexss < db_backup_2010-01-25.sql


but I don't think its working. Are there any other ways of doing it?
dimensio is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 01-26-2010, 03:57 AM Re: how to import 434 mb mysql database
Extreme Talker

Posts: 167
Name: Jilesh
Trades: 0
You can import the database by firing the below mentioned command:

mysql –u [root username] –p [root password] databasename < path to sql backup file [/home/username/backup.sql]
__________________

Please login or register to view this content. Registration is FREE

ASP.NET 3.5 | SQL 2005 Database | US Based Hosting Company | 24 X 7 Support | Daily Backups
|
Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
thewebhostingdi is offline
Reply With Quote
View Public Profile
 
Old 01-26-2010, 04:54 AM Re: how to import 434 mb mysql database
tripy's Avatar
Do not try this at home!

Posts: 3,621
Name: Thierry
Location: I'm the uber Spaminator !
Trades: 0
Quote:
mysql -u dime_succexss -p dime_succexss < db_backup_2010-01-25.sql


but I don't think its working
It should be.
If you don't see anything, then it means it's working.

When you fetch the mysql cli with datas that way, you don't have any feedback until there is an error or everything is finished.
__________________
Only a biker knows why a dog sticks his head out the window.
tripy is offline
Reply With Quote
View Public Profile Visit tripy's homepage!
 
Old 01-27-2010, 09:20 AM Re: how to import 434 mb mysql database
lgl
lgl's Avatar
Junior Talker

Posts: 1
Trades: 0
might be a permissions error, try chmod 777 on the .sql file

Last edited by lgl; 01-27-2010 at 10:43 AM..
lgl is offline
Reply With Quote
View Public Profile
 
Old 01-27-2010, 09:52 AM Re: how to import 434 mb mysql database
Xboxer360's Avatar
Experienced Talker

Posts: 36
Name: Dave
Location: Norwich, UK
Trades: 0
Is Navicat / MySQL Admin not an option? I always use Navicat with large SQL files
Xboxer360 is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to how to import 434 mb mysql database
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.20938 seconds with 12 queries