Restoring DB HELP!

[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

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

[zeroK]

How large is the backup?

[AGN James]

its 542 kb's

Y? plz help

[karim [roi de naples]]

try to cut her ?

[AGN James]

what u mean "try and cut her" ????

[karim [roi de naples]]

to cut your database into parts

[AGN James]

hmm k will try why was that maximum size???

[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

[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?

[SeanMcQ]

If its only 500kbs, there's no need to cut the thing

[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/

[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..

[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