Export whole MySql database

[Franz Marksteiner]

Hi folks,

I am looking for the straightest way to export a whole MySql database, but
all I can find is SQL statements to export specific tables.
Any suggestions?

--
Freundliche Grüße,
Franz Marksteiner

[Jerry Stuckle]

Franz Marksteiner wrote:

Hi folks,

I am looking for the straightest way to export a whole MySql database,
but all I can find is SQL statements to export specific tables.
Any suggestions?

Try a mysql newsgroup - such as comp.databases.mysql. Your question has
nothing to do with PHP.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[icu5545]

On Feb 23, 1:28 pm, "Franz Marksteiner" <[e-mail]>
wrote:

Hi folks,

I am looking for the straightest way to export a whole MySql database, but
all I can find is SQL statements to export specific tables.
Any suggestions?

--
Freundliche Grüße,
Franz Marksteiner

I think PHPMyAdmin will do it. That is, if you have access to that
handy little program.

[Franz Marksteiner]

Jerry Stuckle wrote:

Franz Marksteiner wrote:

>Hi folks,

I am looking for the straightest way to export a whole MySql
database, but all I can find is SQL statements to export specific
tables. Any suggestions?

Try a mysql newsgroup - such as comp.databases.mysql. Your question
has nothing to do with PHP.

Just because the string "PHP" does not show up in my post, does not mean
that the post has nothing to do with it...

So if you ain`t got a clue simply don`t answer...

--
Freundliche Grüße,
Franz Marksteiner

[Jerry Stuckle]

Franz Marksteiner wrote:

Jerry Stuckle wrote:

>Franz Marksteiner wrote:

>>Hi folks,

I am looking for the straightest way to export a whole MySql
database, but all I can find is SQL statements to export specific
tables. Any suggestions?

Try a mysql newsgroup - such as comp.databases.mysql. Your question
has nothing to do with PHP.

Just because the string "PHP" does not show up in my post, does not mean
that the post has nothing to do with it...

So if you ain`t got a clue simply don`t answer...

Oh, I've got a clue. But you sure don't.

This isn't a MySQL newsgroup.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Jerry Stuckle]

Franz Marksteiner wrote:

Jerry Stuckle wrote:

>Franz Marksteiner wrote:

>>Hi folks,

I am looking for the straightest way to export a whole MySql
database, but all I can find is SQL statements to export specific
tables. Any suggestions?

Try a mysql newsgroup - such as comp.databases.mysql. Your question
has nothing to do with PHP.

Just because the string "PHP" does not show up in my post, does not mean
that the post has nothing to do with it...

So if you ain`t got a clue simply don`t answer...

And BTW - if you have a PHP question, what is that PHP question? All
you've asked about is MySQL - and this is not a MySQL newsgroup.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Luuk]

Franz Marksteiner schreef:

Jerry Stuckle wrote:

>Franz Marksteiner wrote:

>>Hi folks,

I am looking for the straightest way to export a whole MySql
database, but all I can find is SQL statements to export specific
tables. Any suggestions?

Try a mysql newsgroup - such as comp.databases.mysql. Your question
has nothing to do with PHP.

Just because the string "PHP" does not show up in my post, does not mean
that the post has nothing to do with it...

So if you ain`t got a clue simply don`t answer...

system("mysqldump <...parameters...>");
for correct '<...parameters...>' please ask in some MySQL newsgroup ;-)

--
Luuk

[Michael Fesser]

..oO(Franz Marksteiner)

>Just because the string "PHP" does not show up in my post, does not mean
that the post has nothing to do with it...

What does dumping a DB to a file have to do with PHP?

Micha

[The Natural Philosopher]

Franz Marksteiner wrote:

Hi folks,

I am looking for the straightest way to export a whole MySql database,
but all I can find is SQL statements to export specific tables.
Any suggestions?

If its on linux, simply go into /var/lib/mysql/databasename and tar the
lot up..if you want a duplicate setup.

I believe that UNLOAD or DUMP will give you a format that you can use to
extract data from..

[Jerry Stuckle]

The Natural Philosopher wrote:

Franz Marksteiner wrote:

>Hi folks,

I am looking for the straightest way to export a whole MySql database,
but all I can find is SQL statements to export specific tables.
Any suggestions?

If its on linux, simply go into /var/lib/mysql/databasename and tar the
lot up..if you want a duplicate setup.

This is not at all safe!

I believe that UNLOAD or DUMP will give you a format that you can use to
extract data from..

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[The Natural Philosopher]

Jerry Stuckle wrote:

The Natural Philosopher wrote:

>Franz Marksteiner wrote:

>>Hi folks,

I am looking for the straightest way to export a whole MySql
database, but all I can find is SQL statements to export specific
tables.
Any suggestions?

If its on linux, simply go into /var/lib/mysql/databasename and tar
the lot up..if you want a duplicate setup.

This is not at all safe!

It is if you stop the mysqld daemon first.

At that point the daemon cleans all up, and flushes all its caches.

You will have a consistent database.

>

>I believe that UNLOAD or DUMP will give you a format that you can use
to extract data from..

[Michael Fesser]

..oO(The Natural Philosopher)

>Jerry Stuckle wrote:

>The Natural Philosopher wrote:

>>If its on linux, simply go into /var/lib/mysql/databasename and tar
the lot up..if you want a duplicate setup.

This is not at all safe!

It is if you stop the mysqld daemon first.

No. It's like copying raw inodes instead of using the appropriate higher
level tools for copying files.

>At that point the daemon cleans all up, and flushes all its caches.

You will have a consistent database.

But maybe with broken or no data at all. Not everyone uses MyISAM
tables. And even with MyISAM there are some things that may screw up
your data in such an operation.

The correct way is mysqldump, that's what this tool is for.

Micha

[Anonymous]

The Natural Philosopher wrote:

If its on linux, simply go into /var/lib/mysql/databasename and tar
the lot up..if you want a duplicate setup.

This is not at all safe!

It is if you stop the mysqld daemon first.

At that point the daemon cleans all up, and flushes all its caches.

You will have a consistent database.

No, Jerry is right. The method you suggested only works with the MyISAM
storage engine.

With any other storage engine (InnoDB comes to mind, which is the most
commonly used today because it supports transactions) your method leads
to data loss. I learned that the hard way.

Bye!

[Jerry Stuckle]

The Natural Philosopher wrote:

Jerry Stuckle wrote:

>The Natural Philosopher wrote:

>>Franz Marksteiner wrote:
Hi folks,

I am looking for the straightest way to export a whole MySql
database, but all I can find is SQL statements to export specific
tables.
Any suggestions?

If its on linux, simply go into /var/lib/mysql/databasename and tar
the lot up..if you want a duplicate setup.

This is not at all safe!

It is if you stop the mysqld daemon first.

Not necessarily.

At that point the daemon cleans all up, and flushes all its caches.

Not always.

You will have a consistent database.

Nope.

>>

>>I believe that UNLOAD or DUMP will give you a format that you can use
to extract data from..

Which is *EXACTLY* why people should ask questions in an appropriate
newsgroup. You will get good answers in comp.database.mysql. The MySQL
experts hang out there.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[The Natural Philosopher]

Anonymous wrote:

The Natural Philosopher wrote:

>>>If its on linux, simply go into /var/lib/mysql/databasename and tar
the lot up..if you want a duplicate setup.

This is not at all safe!

It is if you stop the mysqld daemon first.

At that point the daemon cleans all up, and flushes all its caches.

You will have a consistent database.

No, Jerry is right. The method you suggested only works with the MyISAM
storage engine.

Ok, I concede that point all right.

>
With any other storage engine (InnoDB comes to mind, which is the most
commonly used today because it supports transactions) your method leads
to data loss. I learned that the hard way.

Bye!

[Ivan Marsh]

On Sat, 23 Feb 2008 19:28:24 +0100, Franz Marksteiner wrote:

Hi folks,

I am looking for the straightest way to export a whole MySql database, but
all I can find is SQL statements to export specific tables.
Any suggestions?

Look at mysqldump.

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

--
I told you this was going to happen.