Backing up a MySQL database......

How would I go about doing this? Is there a script out there that will build a .sql file from it so that I can easily rebuild the database or os there some way to get my entire db off the server?

Thanks in advance,
~Chris http://www.extremeforums.com

------------------
"Reality is for people who lack imagination"

On a similar issue - is there a way to transfer a MySQL database from one computer to another? From my experience I haven't heard of a way but if anyone out there has...

For backing up entire MySQL databases' take a look at information on 'mysqldump'.

mysqldump [options] database [table]

Outputs the contents of the given database (or table within a database) as a series of
ANSI SQL commands.

------------------
SnR Graphics,
Low Cost Hosting and Web Development.

I do believe that the same could apply to the second question here.

When you perform the dump, you would then
get a long string of text data, which you could then later execute in a number of formats.

easily turn it into a php file, or whathaveya'

On a side note, mySQL also support incremental backups via: -- log-update option.

This is used by launching you mysqld database server with the above option.

------------------
SnR Graphics,
Low Cost Hosting and Web Development.

The fastest way to do a backup.. is to grab a copy of phpMyAdmin from php wizards.

Use the dump schema options on the main
database page, if you want the database structure and data, select the option and
if you want it in an SQL file, check the
"send" option..

It's fast and simple, and setting the phpMyAdmin up is really very easy, one small
file, upload it (if necessary) and then run it.

------------------
SnR Graphics,
Low Cost Hosting and Web Development.

Beautiful! I have had myphpadmin all along and did not know it could do this. Exactly what I wanted

Thanks for your time.

Chris Miller
P.S Feel free to stop by my php forum anytime and share some knowledge http://www.extremeforums.com

------------------
"Reality is for people who lack imagination"

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by TechTalk:
Beautiful! I have had myphpadmin all along and did not know it could do this. Exactly what I wanted

Thanks for your time.

Chris Miller
P.S Feel free to stop by my php forum anytime and share some knowledge http://www.extremeforums.com
[/quote]

Eh, honestly, I am building my knowledge on this subject as I go along.. you asked a good question, and it just happened to be one that I had been curious about, and was reading on the subject at the time.

I took a shot in the dark on the phpMyAdmin, and tried it before I posted it, that's why I had several responses.

I will stop in and check out the site..

Thanks.

------------------
SnR Graphics,
Low Cost Hosting and Web Development.

Using PhpMyAdmin for large databases/tables with lots of records really is a pain in the ***.

tantrum - thats cos phpMyAdmin has to read from the table its structure, format, field types index's etc - If you have very large tables - you are better off making your own admin page specific to that table - its heaps faster - even my dodgy admin routines are faster than phpMyAdmin for individual tables.

------------------
Simon Wheeler
FirePages -DHTML/PHP/MySQL