Restoring a DB

[sparky]

I'm having problems restoring a DB to my server, it restores to my PC fine. Both are running the same versions Mysql and PHP. The server seems to stop after about 38 tables.Any ideas.Thanks.

[Steve Machol]

How are you restoring it? How was the backup made? My guess is that the backup is incomplete.

[sparky]

Using this:

http://www.vbulletin.com/docs/html/main/maintenance_phpmyadmin_backup

and this

http://www.vbulletin.com/docs/html/main/maintenance_phpmyadmin_restore

Which I used the other day without any problems.

How can it be incomplete if it restores to my XP PC without any problem.

[Steve Machol]

The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

[sparky]

Fine, but that doesn't detract that I have a file that restores to an XP PC and not my server, always stopping with 38 tables completed.

[Steve Machol]

Okay. However this is because the methods you are using are timing out, hence my recommendations in post #4. :)

[sross]

Okay. However this is because the methods you are using are timing out, hence my recommendations in post #4. :)
sorry to jump in, but this thread caught my attention. Steve, do you think i am fairly safe creating backups with mysqldumper? I just started using this app and it seems quite good..

[Steve Machol]

I've never used you so I can't say. I suggest doing a search on these forums to find posts from people who have used it.

[eva2000]

what's your pc's hardware configuration specs vs server's hardware configuration specs as well as their resprective /etc/my.cnf or c:\my.ini contents for pc and server's mysql settings ?