PDA

View Full Version : Database HELP.


daydie
01 Jun 2008, 22:09
(Max: 2,048KiB)

And mine is 36KB....

Says file to big to import, So i can backup from my old database.

How can i get around this.


please help

SEOvB
02 Jun 2008, 00:25
contact your hosting company

Marco van Herwaarden
02 Jun 2008, 08:53
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

WEBDosser
02 Jun 2008, 09:22
i would do it manually (copy&paste) selecting a part at a time of the backup .sql

snakes1100
02 Jun 2008, 15:17
You can upload your backup to the server via ftp and then make a request your host to import it for you, if they refuse or wont help i suggest changing hosts.

or

Use bigdump to import the backup for you, edit the php file and lower this limit if it fails, empty the db via phpmyadmin and try again after you lower this setting:
$linespersession = 3000