Hi

I am at work and despeprately need a sql dump of my site so I can upload to my local phpmyadmin. Is there a php function that can do this.

Thanks
Liam

Try this:
First open the relevant connection as you would normally when using a database. Now use the following php:

PHP Code:

 $tableName  = 'name_of_table';
$backupFile = 'backup/table.sql';
$query      = "SELECT * INTO OUTFILE '$backupFile'       FROM $tableName";
$result = mysql_query($query); 


Simply repeat for all the tables you need backing up.
Hope this helps, Tom

do you have shell access, liam?

You can do this if your server has PHPmyadmin (or similar) where you jsut EXPORT it.

have a look in PHPMyAdmin and it has a Export link, select what you want (probably the default and SQL format)
you can copy it and run the code, or save to a txt file and uplaod to PHPmyadmin and it will run it for you.

Hope this helps
Talkupation appreciated.

this is what I use:

mysqldump [options] db_name [tables]

reference:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html