How to import a complete db

[leegold2]

I have Apachce Mysql PHP on my PC (localhost) at home.
I have a small db with a table or "two".
I want to set up AMP on my PC at work and I want to import
my home db to my work PC (both win32).

Is there a MySQL command that would output/load a db completely
to a file or archive. Then I could ftp or put this object/file on a zip
disk, carry it into work and have it load into the other pc and use it?
Save time vs. recreating the tables passwords from scratch.

A link to a doc. or manual page would be great.

Thanks

[Chris Hope]

leegold2 wrote:

I have Apachce Mysql PHP on my PC (localhost) at home.
I have a small db with a table or "two".
I want to set up AMP on my PC at work and I want to import
my home db to my work PC (both win32).

Is there a MySQL command that would output/load a db completely
to a file or archive. Then I could ftp or put this object/file on a zip
disk, carry it into work and have it load into the other pc and use it?
Save time vs. recreating the tables passwords from scratch.

I posted this about 3 days ago:

To dump and load a database use the mysqldump command line utility eg

mysqldump*-u*username*-p*databasename1 *>*filename.tx t

will dump all tables database structure and data into a file containingall
the insert queries. There are additional flags that can speed this up.

mysql*-u*username*-p*databasename2 *<*filename.tx t

will then load this into the other database. After hitting the enter key in
both cases you'll be prompted for your password.

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/

[leegold2]

Chris Hope wrote:
....snip..

Save time vs. recreating the tables passwords from scratch.

I posted this about 3 days ago:

To dump and load a database use the mysqldump command line utility eg

mysqldump -u username -p databasename1 > filename.txt

Tried it, I get an error:

mysql> mysqldump -u root -p pips > filename.txt
-> ;
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 -u root -p pips > filename.txt' at line 1
mysql> exit

any help appreciated. Thanks.

[Chris Hope]

leegold2 wrote:

Chris Hope wrote:
...snip..

Save time vs. recreating the tables passwords from scratch.

I posted this about 3 days ago:

To dump and load a database use the mysqldump command line utility eg

mysqldump -u username -p databasename1 > filename.txt

Tried it, I get an error:

mysql> mysqldump -u root -p pips > filename.txt
-> ;
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 -u root -p pips > filename.txt' at line 1
mysql> exit

any help appreciated. Thanks.

Run it from the shell command line, not from within the mysql console.

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/

[Shmuel]

mysqldump -u username -p databasename1 > filename.txt

Now it prompts you for a password, but if you do:

mysqldump -u username -ppassword databasename1 > filename.txt

It doesn't ask you anything

Note that mysqldump is a standalone program (MYSQLDIR\bin\m ysqldump.exe)
you have to run it from the command prompt, i.e.
c:\mysql\bin> mysqldump -u username -ppassword databasename1 > filename.txt

[steve]

Another approach is to use phymyadmin. You use the export tab, and
select all the tables and structure and data. Phpmyadmin gives you a
lot of flexibility to choose exactly what you want.

You can even have the output file compressed in pkzip or gzip
automatically, although I have had problems with doing the compression
for large database, but should work fine for small db’s.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-import...ict121164.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=404509

[leegold2]

steve wrote:

Another approach is to use phymyadmin. You use the export tab, and
select all the tables and structure and data. Phpmyadmin gives you a
lot of flexibility to choose exactly what you want.

You can even have the output file compressed in pkzip or gzip
automatically, although I have had problems with doing the compression
for large database, but should work fine for small db’s.

Thanks I used the cnd line and it worked well.