Restoring DB HELP!

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
AGN James
Registered User
Posts: 4
Joined: Mon Jul 14, 2003 5:13 am
Location: Qld, AUS
Contact:

Restoring DB HELP!

Post 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

User avatar
zeroK
Former Team Member
Posts: 20964
Joined: Sun Jan 20, 2002 7:36 pm
Location: Klagenfurt / Austria
Contact:

Post by zeroK »

How large is the backup?
Image My weblog | gamerslog.com | No support via PM or ICQ or email - If you don't know a term or a program mentioned in a post -> Google is your friend

AGN James
Registered User
Posts: 4
Joined: Mon Jul 14, 2003 5:13 am
Location: Qld, AUS
Contact:

Post by AGN James »

its 542 kb's

Y? plz help

karim [roi de naples]
Registered User
Posts: 15
Joined: Tue Apr 22, 2003 4:58 am
Contact:

Post by karim [roi de naples] »

try to cut her ?
Image
Forum - Histoire :: www.forum-histoire.com

AGN James
Registered User
Posts: 4
Joined: Mon Jul 14, 2003 5:13 am
Location: Qld, AUS
Contact:

Post by AGN James »

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

karim [roi de naples]
Registered User
Posts: 15
Joined: Tue Apr 22, 2003 4:58 am
Contact:

Post by karim [roi de naples] »

to cut your database into parts
Image
Forum - Histoire :: www.forum-histoire.com

AGN James
Registered User
Posts: 4
Joined: Mon Jul 14, 2003 5:13 am
Location: Qld, AUS
Contact:

Post by AGN James »

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

Oliver
Registered User
Posts: 93
Joined: Wed Jun 12, 2002 3:49 pm
Contact:

Post 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

Blackhawk_1234
Registered User
Posts: 16
Joined: Sun Jul 13, 2003 10:43 am

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

SeanMcQ
Registered User
Posts: 188
Joined: Mon Oct 28, 2002 2:56 pm
Location: Belfast, Ireland
Contact:

Post by SeanMcQ »

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

Blackhawk_1234
Registered User
Posts: 16
Joined: Sun Jul 13, 2003 10:43 am

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

User avatar
thepaulius
Registered User
Posts: 49
Joined: Thu Apr 03, 2003 1:53 pm

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

titusc
Registered User
Posts: 101
Joined: Fri Sep 27, 2002 10:15 am

Post 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

Locked

Return to “2.0.x Support Forum”