Page 1 of 1

MySQL Export!

Posted: Wed Dec 22, 2004 1:03 pm
by Joe
How could I export my MySQL database to a .sql file. I tried SELECT * INTO however, I was resulted in an error saying that I did not have the appropiate permissions.

Is there another way around this?.

Regards


Joe

Posted: Wed Dec 22, 2004 1:07 pm
by kettle_drum
Use the mysqldump program.

Posted: Wed Dec 22, 2004 1:10 pm
by Joe
I am assuming this is possible with PHP?. You see I am creating my very own database manager (from boredom) and this is the only part I am having troubles with. I did try the mysqldump but I got errors.

Posted: Wed Dec 22, 2004 1:20 pm
by kettle_drum
Oh right...well of course it will be possible to run it with exec() but would be a bit of a hassle. Have you looked to see how phpmyAdmin does it?

Posted: Wed Dec 22, 2004 1:43 pm
by Joe
Yeah, phpMyAdmin was one of the first things I reffered to when I first bumped into the problem but I cannot seem to find the part which creates the dump. I searched through:

export.php
db_details_export.php
libraries/display_export.lib.php

with no luck. It was from then I tried SELECT * INTO and was resulted in errors.