Best way to restore a 300 mb database without ssh access
My host doesnt allow ssh access . so we cant enter commands, to restore and uplaod the 300 mb database? are they any other option
Your best bet is to upload your backup, call them up and have them do it. If they say they can't, tell them that you need SSH access because doing it via phpMySQLAdmin will undoubtedly time out.
If neither works, you need a new host.
Use a third party program like phpmyadmin as suggested, or get a new host. SSH access is quite important for most things.
I can recommend you Mysqldumper (http://www.mysqldumper.de/en/index.php)
I can recommend you Mysqldumper (http://www.mysqldumper.de/en/index.php)
I using this longtime, very good.
my db is around 65/mb and I searched high and low for the utility you're looking for. Just modify this file as needed and run from cgi-bin.
good luck.
#!/bin/sh
#
# Edit this file and put correct string for following items
# MYSQLUSERNAME1&2 MYSQLPASSWORD1&2 mysqlXX1&2 DATABASE_NAME1&2
#
# Don't forget to set permission of 700 (not 755) to this script.
# You can do that with WebFTP, SiteTools, most FTP software, other utilities.
#
echo # Send text/plain Content-type header.
exec 2>&1 # Senf error output (stderr) to the browser
filename=${HOME:-${DOCUMENT_ROOT%/*}/cgi-bin/filename.sql} # ex.: dbbackup_2006-03-07.sql
#echo "Moving MySQL db"
# Dump DB
#/usr/local/bin/mysqldump --opt --no-create-db --user=xxx --password=xxx --host=xxx vbulletin > $filename
#echo "Data saved in $filename.
#Now importing to the destination DB"
echo 'Done'Call the file whatever you want with a .cgi extension.
@morrow thanks for that info.. question is.. how would I run that .cgi file?
how many members/threads/posts/etc comes in your 300mb database?
try this http://www.ozerov.de/bigdump.php it always works
Right now I am doing backups by mounting a second drive array. Then I sync the 2. I unmount the drive array and if the primary ever dies, or I want to roll back, I just switch arrays.
Does your host allow you access to the raw table files..? I generaly have better luck simply backing those up and restoring them than using sql dumps.