Importing large MYSQL database
First off, I am so thankful I found your forum, I love cpanel and whm I am just green, I actually have my vbulletin site up and running but I have a few problems I cant figure out
how to make it possible to upload a big mysql database thru phpmyadmin (Times out)
[img=http://img191.imageshack.us/img191/114/untitled6ay.th.jpg]
Operating System: Red Hat Fedora Core 2
RAM: 512 MB Guaranteed (2 GB Bursted)
Total Disk Space: 10 GB
Bandwidth Allotment: 500 GB
Control Panel Type: cPanel
Last edited by greenchicken; 04-26-2006 at 10:11 AM.
How big is big?Originally Posted by greenchicken
Have you tried using a gzipped copy of the .sql file instead of a plain text version?
gzipped its about 60mb I have shell access but I have no idea how to use it
found this with google...may be of some use if u have shell access
Restoring via the command line
Restoring from FILENAME.mysql is a three step process:
Drop the database
mysqladmin -u USERNAME -p drop DATABASE
Recreate the database
mysqladmin -u USERNAME -p create DATABASE
Import the backup data
mysql -u USERNAME -p DATABASE < FILENAME.mysql
LinkBack URL
About LinkBacks
Reply With Quote