tag:blogger.com,1999:blog-2793719966284028092012-02-07T16:40:18.898-08:00Parag Kalrahttp://www.blogger.com/profile/13414958965440037176noreply@blogger.comBlogger21100tag:blogger.com,1999:blog-279371996628402809.post-13129049449429061492009-01-18T07:48:00.000-08:002009-01-18T09:42:59.106-08:00AIM: To copy a remote database locally and importing all the tables.<br /><br />FILES REQUIRED: db_sync.sh (bash), alter_dbs.sql (mysql)<br /><br />FLOW: db_sync.sh calls alter_dbs.sql<br /><br />REQUIREMENTS: BASH &amp; MYSQL<br /><br />AUTHOR: Parag Kalra (), paragkalra@gmail.com, www.paragkalra.com<br /><br />COMPANY: As of now Persistent System LTD, www.persistentsys.com<br /><br />CREATED: Sunday 18 January 2009 07:00:29 IST<br /><br />LAST CHANGED: Sunday 18 January 2009 07:00:29 IST<br /><br />VERSION: 1.0<br /><br />REVISION: ---<br /><br />EXPLANATION:<br />I have designed my own website "www.paragkalra.com" using LAMP - LINUX, APACHE, MYSQL &amp; PHP. The database is located remotely. Many times I require a copy of remote database on my local setup. So I have prepared a small project which uses two files - The bash script with the help of mysql script first drops the existing databases, recreates the databases, exports the remote databases and finally imports the latest database dump.<br /><br />#!/bin/bash<br />#===============================================================================<br />#<br /># FILE: db_sync.sh<br />#<br /># USAGE: ./db_sync.sh<br />#<br /># DESCRIPTION: To sync the remote database<br />#<br /># OPTIONS: ---<br /># REQUIREMENTS: ---<br /># BUGS: ---<br /># NOTES: -----<br /># AUTHOR: Parag Kalra (), paragkalra@gmail.com, www.paragkalra.com<br /># COMPANY: As of now Persistent System LTD, www.persistentsys.com<br /># VERSION: 1.0<br /># CREATED: Sunday 18 January 2009 12:44:49 IST IS<br /># REVISION: ---<br />#===============================================================================<br /><br />#-------------------------------------------------------------------------------<br /># Storing username, password &amp; logfile in a variable<br />#-------------------------------------------------------------------------------<br />myuser=some_user<br />mypasswd=some_password<br />mylog=/var/log/projects/db_sync.log<br /><br /><br />#-------------------------------------------------------------------------------<br /># Executing a SQL file to create &amp; drop local databases.<br />#-------------------------------------------------------------------------------<br />echo "Executing SQL file - `date`" > $mylog<br />mysql --verbose --user=$myuser --password=$mypasswd --host=localhost < /data/projects/mysql/alter_dbs.sql<br /><br /><br />echo "Dumping remote mysql databases- `date`" >> $mylog<br />mysqldump --verbose --user=$myuser --password=$mypasswd --host=www.paragkalra.com some_database > /data/databases/pkc_db_`date +%F`.sql<br /><br /><br />#-------------------------------------------------------------------------------<br /># Importing the database<br />#-------------------------------------------------------------------------------<br />echo "Importing the database - `date`" >> $mylog<br />mysql --verbose --user=$myuser --password=$mypasswd some_database < /data/databases/pkc_db_`date +%F`.sql echo "Export - Import of database complete - `date`" >> $mylog<br /><br /><br /><br /><br />#===============================================================================<br />#<br /># FILE: alter_dbs.sql<br />#<br /># USAGE: ---<br />#<br /># DESCRIPTION: To drop and recreate the databases<br />#<br /># OPTIONS: ---<br /># REQUIREMENTS: ---<br /># BUGS: ---<br /># NOTES: ---<br /># AUTHOR: Parag Kalra (), paragkalra@gmail.com, www.paragkalra.com<br /># COMPANY: As of now Persistent System LTD, www.persistentsys.com<br /># VERSION: 1.0<br /># CREATED: Sunday 18 January 2009 07:00:29 IST IST<br /># REVISION: ---<br />#===============================================================================<br /><br /><br />#-------------------------------------------------------------------------------<br /># Dropping the databases if they exists<br />#-------------------------------------------------------------------------------<br />DROP DATABASE IF EXISTS `some_database `;<br /><br />#-------------------------------------------------------------------------------<br /># Creating databases<br />#-------------------------------------------------------------------------------<br />CREATE DATABASE `some_database `;<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/279371996628402809-1312904944942906149?l=discoverprojects.blogspot.com' alt='' /></div>Parag Kalrahttp://www.blogger.com/profile/13414958965440037176noreply@blogger.com0tag:blogger.com,1999:blog-279371996628402809.post-27697127421749683282008-12-28T09:48:00.000-08:002008-12-28T09:49:45.743-08:00Coming soon...<div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/279371996628402809-2769712742174968328?l=discoverprojects.blogspot.com' alt='' /></div>Parag Kalrahttp://www.blogger.com/profile/13414958965440037176noreply@blogger.com0