Page 1 of 1

Restoring DB HELP!

Posted: Mon Jul 14, 2003 5:17 am
by AGN James
Hey I work for www.ausgaming.net AGN and I host alot of ppl I'm not that gr8 with restoring DB on phpbb forums.

One of my clients has giving me his SQL backup file and wants me to restore his forums as he accidentally stuffed em up. Now I dont know how to do this :cry:

Can someone tell me what to do? Plz

Now of the top of my head I think I tried going into phpadmin opening his database and then going to SQL and uploading the backup saved file there but that didnt work. Then I went into Administration section on the forums and tried restoring DB uploaded it again but nothing happened.

Can SOMEONE please help ME!

L8ter All James

Posted: Mon Jul 14, 2003 6:24 am
by zeroK
How large is the backup?

Posted: Mon Jul 14, 2003 10:21 am
by AGN James
its 542 kb's

Y? plz help

Posted: Mon Jul 14, 2003 10:23 am
by karim [roi de naples]
try to cut her ?

Posted: Mon Jul 14, 2003 10:58 am
by AGN James
what u mean "try and cut her" ????

Posted: Mon Jul 14, 2003 11:03 am
by karim [roi de naples]
to cut your database into parts

Posted: Mon Jul 14, 2003 12:06 pm
by AGN James
hmm k will try why was that maximum size???

Posted: Mon Jul 14, 2003 12:08 pm
by Oliver
Depends on the settings of your webhost. Usually round 1mb maybe 5mb. I'd go for the 1mb.

It would be even better if you would have telnet/ssh access, then you could simply dump and restore it in one go.

Backup:
mysqldump -u username -p databasename > forum_backup.sql

Restore:
mysql -u username -p databasename < forum_backup.sql

Posted: Mon Jul 14, 2003 12:14 pm
by Blackhawk_1234
the back up file is phpBB 2.0.4 ... would it still work on trying to restore it to a phpBB 2.0.5 forum?

Posted: Mon Jul 14, 2003 1:58 pm
by SeanMcQ
If its only 500kbs, there's no need to cut the thing

Posted: Tue Jul 15, 2003 12:27 am
by Blackhawk_1234
sean would my suggestion work mate? ... if it is able to work, then ill send u ftp info through a pm .. this is my forum address btw http://ck.ausgaming.net/forum/

Posted: Wed Jul 16, 2003 3:20 pm
by thepaulius
i have the same problem. it just doesnt seem to read the file and restore anything.. major bad thing if it screws up!

im trying to transfer my phpbb to another server..

Posted: Wed Jul 16, 2003 9:29 pm
by titusc
Hello,

I am sorry but can someone please explain the difference between

Code: Select all

Backup: 
mysqldump -u username -p databasename > forum_backup.sql 

Restore: 
mysql -u username -p databasename < forum_backup.sql
and this

Code: Select all

Backup: 
% /usr/bin/mysqldump --quick -uuser -ppassword database | /bin/gzip -6 > /root/backup/mysql/database.sql.gz 
 
Restore: 
% /bin/zcat /root/backup/mysql/database.sql.gz | /usr/bin/mysql --quick -uuser -ppassword database -  
If I am going to run the backup/restore as a crob job, which one should I use? How can I disable the board before running these?

Thanks
Titus