PDA

View Full Version : Help need for database

ITDarasgah
10-03-2009, 03:23 AM
Hi,
I am moving my forum to new server and all files is shift but I don't move the database then I try to do that I have this error please help me how can move my database
I am tried to pull a backup and get the following notice.

[ ! ] ************************************************** ************* [ ! ]
[ ! ] WARNING: Your account is TOO LARGE (Over 4gb) for cPanel backups. Please contact support. [ ! ]
[ ! ] ************************************************** ************* [ ! ]
Lynne
10-03-2009, 03:33 AM
Take a look at these pages in the manual regarding creating backups (and importing backups):

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)
WEBDosser
10-03-2009, 05:50 AM
i would imagine the 4gb is mostly images so before the move i would suggest you change the attachments to file storage instead of database, then your mysql should not be so large.

wD
ITDarasgah
10-03-2009, 04:05 PM
i would imagine the 4gb is mostly images so before the move i would suggest you change the attachments to file storage instead of database, then your mysql should not be so large.

wD

Thank you friend ...I am doing to do that but have this error
Parse error: syntax error, unexpected $end, expecting ',' or ';' in /home/my name/public_html/admincp/attachment.php on line 580
WEBDosser
10-03-2009, 05:07 PM
make sure you have setup the attachments dir correctly and given it chmod 0777
ITDarasgah
10-03-2009, 05:22 PM
make sure you have setup the attachments dir correctly and given it chmod 0777

Please guide me were to make that dir on server
snakes1100
10-03-2009, 06:50 PM
You can make it any place in your FTP.

/home/my name/attachments
or
/home/my name/public_html/attachments
ITDarasgah
10-03-2009, 07:05 PM
You can make it any place in your FTP.

/home/my name/attachments
or
/home/my name/public_html/attachments

I do that all then I click on the Attachment Storage Type in Admin Cp but I can't see any option for more Information Please see the Image
Note: the SAFE_MODE for my site is already disable
105037
snakes1100
10-03-2009, 07:13 PM
Getting a blank page says you have other issues, use THIS LINK (http://www.vbulletin.com/docs/html/main/blank_pages) to solve the blank page issue.
ITDarasgah
10-03-2009, 09:17 PM
Getting a blank page says you have other issues, use THIS LINK (http://www.vbulletin.com/docs/html/main/blank_pages) to solve the blank page issue.

Thank you so much....now its done.:)
WEBDosser
10-04-2009, 04:16 AM
cool.. so now how big is your database?.