My current host is horrible, so Iam trying to move my Vb forums. The backup wizard in the CP is down and has been for a month, myphpadmin does not work due to the size of the Db. Mysqldumper was not working due to a memory error. The Http is down so I cant access the site, so I cant even run mysqldumper right now..lol How can I make a backup so I can try to get away from the problems with my host? Iam a complete newbie when it come to Db backups so if I can can any help I would appreciate it. Thanks in advance
without http access? you're wasted you need it at least if you have money for this job I can help but I require http and ftp at least
I just got Http back, I would prefer to do it on my own so I can learn how, when all else is exhausted I will pay someone to do it. How much are you looking for to do the job? My attachment table alone is 1.05 gigs. I am getting the following error when I try the attachment table backup. Fatal error: Allowed memory size of 25165824 bytes exhausted (tried to allocate 3431235 bytes) in /home/*****/public_html/mysqldumper/inc/functions_dump.php on line 174 Any Ideas?
SSH into your server. Then run the following command... mysqldump -u [username] [tablename] > outputfile.sql If you're getting a memory error from that then just restart your server and run that immediately after it restarts.
First check to be sure that your server even allows you SSH access. Most cheap hosting accounts do not. A good hosting account, VPS, or dedicated server will allow you to. Second, go to download.com and get AbsoluteTelnet. Put in your IP/domain and use whatever login information you got from your hosting service. You might have to contact your support team because sometimes they won't offer you SSH service unless you ask for it.
Nope cant SSH in, any other ideas? My current host takes days to return any support tickets, so Im kinda hooped here...lol Thanks for helping Is there a program like mysqdumper that allows you to save the db to your pc instead of the server? Maybe then I would have the limitations and memory errors?
Have you tried a program on your PC and connect to the database remotely? I do it all the time and have no trouble backing up large databases. Just as you would use an FTP program to transfer files to the server (instead of using the control panel file manager), you could use a MySQL program to connect to the database and back it up that way. Personally, I use MySQL-Front. Never had a problem with it. I've never backed up a database of over 1 Gig but I did back up a 630 Megabyte database without any problems... so I can't see any problems with a 1 Gig. If you need help with this task and would like someone to complete it for you - PM me and we can go from there.
thanks nyxano, Im trying out the MySQL-Front... Now as long as my server stays up long enough to do it I will post the results... Thanks everyone for the help