A3
|
| Posted: 09/01/2005, 5:07 PM |
|
Does anyone know of an easy method to dump a mysql table using php to a .sql file on my local machine.
Using mysqldump stores the file on the server, but I would like to store it on my local machine.
|
|
|
 |
DonB
|
| Posted: 09/01/2005, 8:14 PM |
|
The general concept is to stuff the data onto a page rather than to a file,
which I'd suggest browsing the code for PhpMyAdmin to get the specifics on
how to do it: http://www.phpmyadmin.net/home_page/index.php. I suppose
it's doing something simple like changing stdout to send it to the browser,
but I haven't looked at their code.
For CCS, you'd want to get the dump into a PHP variable, which could then be
assigned to a Label control in its Before Show event.
--
DonB
http://www.gotodon.com/ccbth
"A3" <A3@forum.codecharge> wrote in message
news:5431797baed5ec@news.codecharge.com...
> Does anyone know of an easy method to dump a mysql table using php to a
..sql
> file on my local machine.
> Using mysqldump stores the file on the server, but I would like to store
it on
> my local machine.
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Michael Mikkelsen
|
| Posted: 09/02/2005, 8:26 AM |
|
This is what I use:
www.myadmin.org
Their website home page seems to be down at the moment but you can download it here:
http://www.goodfiles.com/viewapp.asp?app=database_tools/myadmin.xml
It is shareware, free trial.
MYdbPAL is also a very powerful product for doing this but it has a slightly high learning curve. It's free.
http://www.it-map.com/html/mydbpal_.html
If you want to do it using PHP as you suggested check out:
http://www.phpmyadmin.net
I haven't used it lately but I bet it can do what you want and it's written in php. I think it's a open source project. "community" projects always have really good code because everybody sees the code and who wan't to look bad in the community?
Of those 3 you shouldn't have trouble finding one that you like.
|
|
|
|
Alvaro Cobo
|
| Posted: 09/02/2005, 9:26 AM |
|
You could also try to sudy de code from phpMyBackup
(http://www.phpmybackuppro.net/). It is free and open source.
Regards,
Alvaro
"A3" <A3@forum.codecharge> escribió en el mensaje
news:5431797baed5ec@news.codecharge.com...
> Does anyone know of an easy method to dump a mysql table using php to a
..sql
> file on my local machine.
> Using mysqldump stores the file on the server, but I would like to store
it on
> my local machine.
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
