...

View Full Version : Exporting MySQL Tables



UrbanTwitch
02-23-2009, 05: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, 05:40 AM
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

Will that not do what you need???

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

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

BubikolRamios
02-23-2009, 05: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, 05: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.

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

Old Pedant
02-23-2009, 07: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.)



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum