exporting mysql

[Andy Levy]

Hi

there is a function in phpmyadmin that exports all the data etc from a mysql
database to an sql text document, or Excel File.

I would like to know if there is an inherent way of doing this without
phpmyadmin. - straight through php.

thank you

andy

[Dan Tripp]

Andy Levy wrote:

Hi

there is a function in phpmyadmin that exports all the data etc from a mysql
database to an sql text document, or Excel File.

I would like to know if there is an inherent way of doing this without
phpmyadmin. - straight through php.

thank you

andy

mysqldump will do this for you.

Usage: mysqldump [OPTIONS] database [tables]
http://www.mysql.com/doc/en/mysqldump.html
From a php script, you could probably use exec();
http://us2.php.net/exec
- Dan
http://blog.dantripp.com/

[Carlos Marangon]

Hello!
I am also looking for that.

As far I know PhpMyAdmin can easily be installed in any PHP server,
with MySQL support.
I have it installed even in my localhost.

If nobody else gives you a direct answer,
I think you can look inside of PhpMyAdmin code and
locate the part of the code that do it.

If nobody else answer I will try to do it,
because as you, I also need this code.
And worse, I need to export MySQL to Access.
Download PhpMyAdmin from
http://www.phpmyadmin.net/
[]

Carlos

"Andy Levy" <an*******@hotmail.com> wrote in message news:<v%*****************@news-binary.blueyonder.co.uk>...

Hi

there is a function in phpmyadmin that exports all the data etc from a mysql
database to an sql text document, or Excel File.

I would like to know if there is an inherent way of doing this without
phpmyadmin. - straight through php.

thank you

andy

[Tim Van Wassenhove]

On 2004-02-03, Carlos Marangon <ar****@hotmail.com> wrote:

"Andy Levy" <an*******@hotmail.com> wrote in message
news:<v%*****************@news-binary.blueyonder.co.uk>...

Hi

there is a function in phpmyadmin that exports all the data etc from
a mysql
database to an sql text document, or Excel File.

http://www.phpfreaks.com/tutorials/114/0.php

--
http://home.mysth.be/~timvw

[Rahul Anand]

"Andy Levy" <an*******@hotmail.com> wrote in message news:<v%*****************@news-binary.blueyonder.co.uk>...

Hi

there is a function in phpmyadmin that exports all the data etc from a mysql
database to an sql text document, or Excel File.

I would like to know if there is an inherent way of doing this without
phpmyadmin. - straight through php.

thank you

andy

You can use MySQL command *mysqldump* to generate SQL Text file for
databases and tables. You can also run this command in a PHP script by
calling system command.

To dump your data in Excel Portable file, you can use MySQL command:

SELECT *
INTO OUTFILE "/tmp/result.text"
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n"
FROM test_table;

This will dump data in CSV format, which can be read by MS Excel
program.

--
Hope it will help,
Rahul Anand