mysqldump - problem with creating one table backup file

[Marcin Zmysłowski]

Hello!

I would like to export the structure table and all table data into the one
sql file.

I would like to have one create table text and insert commands in one file.

How I can achieve it?.
I don`t want to export all tables and all table structures from the one
database into the one file.
I would like also have the exported files zipped.

I tried to do this in phpmyadmin

mysqldump -a my_name_database >
F:/xampp/htdocs/test/temp/backup_results/test.sql
or
mysqldump -a `my_name_database` >
`F:/xampp/htdocs/test/temp/backup_results/test.sql`
or
mysqldump -a 'my_name_database' >
'F:/xampp/htdocs/test/temp/backup_results/test.sql'
or
mysqldump -a -u test -p my_password my_name_database >
F:/xampp/htdocs/test/temp/backup_results/test.sql

but I got the error

#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'mysqldump -a `zmyslowski_pl_serwer` > `F:/xampp/htdocs/test...

Can you help me?
Thank you in advance
M.

[Paul Lautman]

mysqldump is a shell program. You run it in a console.

[Marcin Zmysłowski]

Użytkownik "Paul Lautman" <paul.l...@btinternet.com> napisał w wiadomości
news:6ee55kF...@mid.individual.net...

Thank you.
Ok I see. So how can I create such files in php?

M.

[Paul Lautman]

You could issue the command to the shell.

[Luuk]

Marcin Zmysłowski schreef:

how to do it with phpMyAdmin is at:
http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/3/
and
http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/4/

--
Luuk