Exporting Mysql Forum

[Dj Sagi]

How I Do It In The Fastest Way?
Thx.

[Lynne]

From the manual:
Backing Up The Database via SSH/Telnet (http://www.vbulletin.com/forum/../docs/html/maintenance_ssh_backup) or
Backing Up The Database via phpMyAdmin (http://www.vbulletin.com/forum/../docs/html/maintenance_phpmyadmin_backup)

Restoring The Database via SSH/Telnet (http://www.vbulletin.com/forum/../docs/html/maintenance_ssh_restore) or
Restoring The Database via phpMyAdmin (http://www.vbulletin.com/forum/../docs/html/maintenance_phpmyadmin_restore)

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)

[Dj Sagi]

I Know It But U Have Faster Way?
Thx For Help!

[Lynne]

Why would you think that isn't fast? How do you figure to make it go faster?

[Mr-Moo]

The fastest method in backing up an SQL database remotely is via SSH. Learn it, use it, love it.

SSH is the best method for exporting/importing any sensetive information that can get corrupt during a transfer.

Here is what I do with 50+MB databases:
-GZAR with a linux machine or Winrar on a Windows box.
-Upload via FTP as a GZAR
-Connect to SSH and extract/import. Follow the websites provided by Lynne.

That is the quickest method of exporting/importing a database.