alohatofu Posted April 19, 2007 Share Posted April 19, 2007 Good morning folks, I was wondering if someone could give me some guidance in mirroring 2 databases with their username and password. I have 2 databases that I would like to mirror with the username and password. Is it possible if so, please help. Do i setup a script? cronjob? Thank you! Link to comment https://forums.phpfreaks.com/topic/47725-mirroring-username-and-password/ Share on other sites More sharing options...
monk.e.boy Posted April 19, 2007 Share Posted April 19, 2007 crontab + mysqldump + scp? That's what I do, or I do FTP instead of scp. If you are unsure, google around for the above Linux programs, and also "mysql backup" I set the server cron job to run at 23:30, this dumps the db, it also gzip's it (mysqldump --switches etc | gzip db.sql.gz) Then on the backup server I have a cron job that runs at 00:30 and FTPs to the server, downloads the gz file, unzips then imports it into mysql. Always import the sql, you HAVE to check that it is valid. monk.e.boy Link to comment https://forums.phpfreaks.com/topic/47725-mirroring-username-and-password/#findComment-233099 Share on other sites More sharing options...
alohatofu Posted April 19, 2007 Author Share Posted April 19, 2007 I do not want the whole database, just the filed usrname and password. What i was thinking was do a script to connect to the other dabase and check the field and mirror the field. Link to comment https://forums.phpfreaks.com/topic/47725-mirroring-username-and-password/#findComment-233109 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.