Downloading MySQL Tables and Data

[Bioshox]

Hey

I want to make a MySQL Backup Script, but I'm not sure how to do it

I want to download the SQL Data and Tables and save it to a file

Any idea how to do this!?

[BlaineSch]

phpMyAdmin has a useful feature for this, but if you want you can do the queries yourself.


MySQL :: MySQL 5.1 Reference Manual :: 6.2 Database Backup Methods

Basically lock, download, unlock.. :]

[Bioshox]

This doesn't really help me as I'm not that well up with MySQL Query Commands, only UPDATE, INSERT & DELETE, do you have any examples?

[Orjan]

Easiest is as Blaine said, with the Export function in phpMyAdmin

[Bioshox]

Yeah, although I'm building a community system, so id like to be able to download the SQL tables from within the system, or at least for the user to, like you can do on PHPBB, SMF, IPB, Wordpress, ect!

Sorry to be such a pain, iv tried Google, but it failed me!

[Orjan]

Hope not to be rude, but I think you should learn a lot more SQL to achieve your goal, this seems like this is a way too big task for your current knowledge, so try to fix things one by one in smaller tasks than a giant project than this...

[Bioshox]

This forum system sucks, everytime I try to post it just redirects me to the homepage, anyway...

I just can't work out how to download the MySQL tables, like I said in a previous post I'm okay with all other aspects my MySQL, I just can't figure out how to download them, I have the installation script for setting up the system which inserts, tables and data, but it would be a great feature to have a Backup System function within the ACP.

Although I will look around Google more for information on this,

Thanks for your help .