var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
Cron job request
would you give me a script for cronjop to be able to restore db
If you are adding a cron job to restore a database, you will need to drop that database first., or the restore will give error.
Something like this will do.
mysqladmin -f drop dbname
mysqladmin create dbname
mysql dbname < path to the sql file
Add this to a file and run the file as the cronjob.
Which file ?
Originally Posted by david510
Where file ?
Dan - Vice President - [email protected]
BurstNET Technologies - http://www.burst.net
can i run folllowing commands using cron
Originally Posted by burstdan
mysql -u zodehala -p123 db < backup.sql
mysqldump -u zodehala -p123 db | bzip2 -c > backup.sql
But why do you want to do it via cronjob?
cronjob/crontab is used to do some task repeatedly at certain interval of time, do you want to restore some db every few hours or minutes? if not then you don't need do it via cronjob
Last edited by funtoosh; 12-21-2006 at 05:54 AM.
there are no SSH an any restore tools
Originally Posted by funtoosh
how can i restore db (my db is 750MB)?
Last edited by zodehala; 12-21-2006 at 07:57 AM.
zodehala: what exactly do you have to work with? without ssh it's gonna be difficult. most web interfaces have a limit on the amount of data that can be uploaded.
Just upload it via ftp and ask your web hosting provider (as you don't have ssh access so i take for granted you don't have root access on it) to restore it for you
Originally Posted by zodehala
Thanks for all
İ know db master in my hosting can restore db instead of me and
i know restore / back up db using ssh (phpmyadmin for small db )
i want to know that is there any way to restore db except aboves ?