View Full Version : Exporting MySQL Tables

02-23-2009, 06:12 AM
Hello, I am making a news script and I need a way so people can create backups using .sql files.

See, I need a script which will export a certain MySQL table into a .sql file wit the current data on it. Is that possible?

Old Pedant
02-23-2009, 06:40 AM

Will that not do what you need???

02-23-2009, 06:48 AM
I need a php script that exports MySQL tables.

Plus, I don't know what a shell is. :(

02-23-2009, 06:56 AM
shell is equivalet to windows dos prompt
mysqldump is executable
then you can wrap that into .bat or something, can be run from php I hope.

Old Pedant
02-23-2009, 06:59 AM
Bubikol is correct. If you are able to invoke executable programs from PHP, then that would be the way to do this.

How hard that is--if it's even possible--probably depends on what operating system you are using.

02-23-2009, 07:20 AM
But is it possible to run a mysqldump on a web page using PHP?

Old Pedant
02-23-2009, 08:49 AM
I don't know PHP well enough to be able to answer that.

If it were ASP/ASP.NET on a Windows server, then the answer would be "it depends on what permissions/settings the web administrator has given you."

I think maybe you could ask the question in a PHP forum. Be sure to specify exactly what operating system you are using. (That is, if Linux, be sure to say what "flavor" of Linux, etc.)