The fastest way to restore using phpmyadmin ?

[deathemperor]

It's bad that I don't have SSH access to my hosting so I guess I'll have to restore my board using phpmyadmin.

my backup file is .gz and 18MB, now using phpmyadmin from my hosting CPanel I can hardly run that file, because it's too big to upload via http.

Someone knows any better solutions ?

Thanks in advance.

[noppid]

Use a cron job. Make sure you use full paths to files.

[deathemperor]

can you point it to me clearer ?

AFAIK the cron job hacks here need SSH access.

[tnguy3n]

you can indeed set cron job in Cpanel.

[deathemperor]

thanks, I figured that way but how darn my backup was corrupted, I wasn't backupped properly >_<

[tnguy3n]

re-download the gunzip file and re-ftp to the server.
I've never tried to restore database using cron job, but you can try this one.

 5 * * * * /usr/local/mysql/bin mysql -u ACCOUNT -p PASSWORD vb_dbname < /home/ACCOUNT/public_html/file.sql

Manually hit the Run cron job button or wait for 6-7 mins, then delete the cron job.

[filburt1]

Never ever back up using a PHP method, including phpMyAdmin. Absolutely always do something entirely server-side, then transfer the backup to another machine.