Status
Not open for further replies.

only1_PO

Banned
Banned
298
2008
2
0
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
 
7 comments
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[])
 
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?
 
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.
 
Status
Not open for further replies.
Back
Top