Perfect way of upload a large sql database

Toopac Peon

Messages:: 4,451

Likes Received:: 166

Best Answers:: 0

Trophy Points:: 0

#21

For large files via phpmyadmin use this script.

Toopac, Nov 23, 2009 IP

sweta.singh.98 Guest

Messages:: 628

Likes Received:: 2

Best Answers:: 0

Trophy Points:: 0

#22

Dennis M. said: ↑
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.
Click to expand...
hi buddy thanks for reply i think it is the most perfect and simple way ..........

sweta.singh.98, Nov 24, 2009 IP

sviedinys Member

Messages:: 42

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 41

#23

try phpmyadmin and import database

sviedinys, Nov 29, 2009 IP

inanobot Peon

Messages:: 46

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#24

http://forums.digitalpoint.com/showthread.php?t=1590262#post13012928

inanobot, Nov 30, 2009 IP

Fruit&Veg Peon

Messages:: 21

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#25

Heres a fantastic tutorial on how to use big dump: You might want to watch viedo 2 of 2 which covers how to FTP BigDump etc.

http://www.youtube.com/watch?v=iWsbOqd-1v4&feature=related

Fruit&Veg, Dec 1, 2009 IP

sweta.singh.98 Guest

Messages:: 628

Likes Received:: 2

Best Answers:: 0

Trophy Points:: 0

#26

Fruit&Veg said: ↑

Heres a fantastic tutorial on how to use big dump: You might want to watch viedo 2 of 2 which covers how to FTP BigDump etc.

http://www.youtube.com/watch?v=iWsbOqd-1v4&feature=related
Click to expand...

ok....

Thanks for this link ....

sweta.singh.98, Dec 1, 2009 IP

Log in or Sign up

Perfect way of upload a large sql database

Toopac Peon

sweta.singh.98 Guest

sviedinys Member

inanobot Peon

Fruit&Veg Peon

sweta.singh.98 Guest

Useful Searches