PDA

View Full Version : Export / import user on phpMyAdmin


aircool52
16 Jul 2008, 20:55
Some one can tell me how to export / import user from phpMyAdmin , I did once good , but all others times gave an error or incomplete file?:confused:

--------------- Added 1216260623 at 1216260623 ---------------

Some one can help?

Marco van Herwaarden
17 Jul 2008, 09:47
You can not backup & restore a single table. You will always need to backup/restore the entire database.

The only 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 timeouts 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

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php

aircool52
17 Jul 2008, 17:08
I can't do that because the new host does not have telnet or ssh , and also I did before but do no remember , a single table "user" I have export and import without any trouble.

Dismounted
18 Jul 2008, 08:53
Read the whole message ;).