Is it possible to automate to mirror mysql datbase on another server (Free hosting server). With purely PHP.
Deepak
"With purely PHP."
Do you mean 'make a copy' or 'set up a replication scheme'?
I got two sites hosted on two diferrent free servers with mysql
one is a backup for the other so I need it to backup each other
Me doing that with a single click or automatically
Is it possible.
You can use mysqldump to write a textfile containing the entire database, and you can pipe that through the mysql commandline program to load it directly into a backup database if you want.
I am comparatively a newbie can you develop a script or is there any script available.
Also one mre thing I always have problems with sql statements is there any wizard which can help (I spent 1/2 hrs to trace my error in INSERT statement)
Thank you Deepak
1) read the MySQL manual about mysqldump.
2) everytime a query fails, print mysql_error(), that will tell you why it failed. Also, get yourself a decent frontend, like 'mysqlfront' for windows. That will help you test your queries.
