MySql Backup Script

SumitGupta

Hi..

I need a backup script that will backup all my database which is online to my pc.

The problem is that i doesn't know how to make my script to read the structure of my online database. I want my script to read the number of table and column in my online database and than create the same on my local pc. I have a connection script that i will call from my pc which will make the online database connection and select my DB than ???? is what i require...before it actual read the database and insert it into my local pc

Thanks for quick help

tsinka

Hi,

it might be easier to use the command line tools that come with MySQL like mysqldump. You can do something like this:

A) Dump
mysqldump --add-drop-table -uuser -p -honlinehost dbname > dump.sql

😎 Import
mysql -uuser -p -hlocalhost -Ddbname < dump.sql

You first need to create the target database on your PC.

The argument --add-drop-table adds DROP TABLE ... queries to the dump file so that the tables on the PC will be recreated.

Thomas

SumitGupta

Hi..

Well your answer doesn't fulfill my requirement...

1) I need a php script for this so other tools are out of question
2) As per my company rule i doesn't have access to db directly and i am bound to use the connection script they provide me. Now, I have to use that connection to backup the data....Like this once the connection is switch from one database to other the other site data will be backup by the Same script....

Though there are many other method none but company need what they need@##$#

So please help me in that way