How to restore mySQL

[only1_PO]

I need to restore MySQL, but it is bigger than 50mb, so I can't do that by phpMyAdmin. Can someone send me some link where I can find explanation?
Software: phpBB 3.0.5
Thx

only1_PO Reviewed by only1_PO on 21st Nov 2009. How to restore mySQL I need to restore MySQL, but it is bigger than 50mb, so I can't do that by phpMyAdmin. Can someone send me some link where I can find explanation? Software: phpBB 3.0.5 Thx Rating: 5

[CyberPirate]

Thurr

http://www.ozerov.de/bigdump.php

[only1_PO]

Thank you CyberPirate

[Juo]

Thanks for the link CyberPirate, bookmarked.

[Sandino]

You could also possibly ask your host to do it, mostlikely they will

Big dump does work for certain things, but not all.

[Rutti]

it's easier if you do it by logging in through ssh and run:

to dump it to a file:
#mysqldump --opt -u[dbusername] -p[dbpassword] dbname > dbname.bak.dump

to restore/rebuild a database:
#mysql -u[dbusername] -p[dbpassword] dbname < dbname.bak.dump

(without the brackets[])

[only1_PO]

it's easier if you do it by logging in through ssh and run:

to dump it to a file:
#mysqldump --opt -u[dbusername] -p[dbpassword] dbname > dbname.bak.dump

to restore/rebuild a database:
#mysql -u[dbusername] -p[dbpassword] dbname < dbname.bak.dump

(without the brackets[])

For people like I'm this is high mathematics. Have you some step by step tutorial?
And how to use that ssh, what software for that?

[Rutti]

well you need shell access to your server, if you have a dedicated server you should have this. You can use for example putty to ssh to the server (http://www.putty.org/).

if you want to get better at server management you should play around with your server in putty, there are TONS of information online on how to do all sorts of stuff, like tweak your server for speed, mysql optimization, etc. etc.