Perfect way of upload a large sql database

hi

i have a database of 300mb and i want to upload it in mysql but don't know how . i have searched the perfect way to do this but not get any best way i don't know about ssh i got many articles to do it by ssh but not able to do this ..

also i tried bigdump.php but its also not working ....can any buddy can explain it step by step how to do this ....or can give a perfect article regarding this ..

Thanks ........

 

Try using mysqldumper instead: http://www.mysqldumper.de/en/

 

First, create a database through your control panel. Give it a name, then give a user full access to it, with a password. Upload your database backup (.sql file) through ftp to your websites root, in most cases, you should be able to see the public_html folder, not be in it. Then, through ssh, navigate to the root of your account, then issue the following command, of course, replacing the variables with your own:

mysql dbname < filename.sql -u user --password=pass

 

bigdump actually works..
can you post the error that your are getting while restoring the db ?

 

I've had great success with BigDump. Are you getting an error message?

 

BigDump should work just fine -

 

If you have control panel access make use of phpmyadmin for importing the data.

It is the easiest method

 

thanks for ur suggestions its works and i have done this .....

 

it is very simple......try phpmyadmin and import database...

 

yes u r right but in case of large data base it not works ..

 

bigdump works fine for me... maybe you just didn't configure it right

 

hmm... on some hosting you can... you just have to submit the same file more times... and it just continues where it stopped.

 

Shell is the fastest and the best way for a large database

 

yes Bohra u r right i have done it and hardly it takes 3-4 secs in uploading 300MB database . I was Shoked to see that ..

 

Thanks alot the above posts help alot.

 

By far the best way to do it is by using a mysql dumper.

 

yes this is also helpfull....

 

Can someone tell me how to use SSH to upload the DB?I have never used SSH before

 

This is also done within a shell.

However, in response to the above question, you need to know where you are at. First type 'ls' (No quotes; assuming this is a Linux machine). In most cases you will see your root directory containing your public_html. By this time, you should have uploaded your database backup file to the server via FTP. Go to the directory where you uploaded that file using the 'cd' command. For example, the following will take me to my cgi-bin located within my public_html:

cd ~/public_html/cgi_bin

Code (markup):

the ~ character just states that I want to start in MY root directory. But now that you have found the file type 'ls' again to be certain it's there. Found it? Great! Now we will use mysqldump. It should already be installed on your server - it's part of MySQL.

mysqldump -u <DB_USER> --password=<DB_PASS> <DATABASE_NAME> <  <BACKUPFILE.SQL>

Code (markup):

And there is your code. Just replace the variables with appropriate information (make sure to remove the brackets) and your database should be quickly restored!

A working example will look like this:

mysqldump -u test --password=test123 test_database < test.sql

Code (markup):

Regards,
Dennis M.

 

300 megs through phpmyadmin? You're nuts. Especially considering most default php installs are set to 2 megs.

Granted your own may be different but I run into that 2 meg limit quite often on support forums.