How do I copy a db?

[Manny]

My website uses php/mysql/linux and is hosted by a local web-hosting
company. I access the db via cpanel/phpmyadmin and currently perform
all testing and changes on the live db and website ( not good!).

I would like a copy of the db on my own machine at home so I can test
locally rather than on the live db.
I have successfully installed mysql at home (on windows) and now I'd
like to get a copy of the db and data and would like to put this on my
db at home.

How is this possible?

Thanks in advance.
Manny

[Thomas Bartkus]

"Manny" <ma******@hotmail.com> wrote in message
news:3e*************************@posting.google.co m...

My website uses php/mysql/linux and is hosted by a local web-hosting
company. I access the db via cpanel/phpmyadmin and currently perform
all testing and changes on the live db and website ( not good!).

I would like a copy of the db on my own machine at home so I can test
locally rather than on the live db.
I have successfully installed mysql at home (on windows) and now I'd
like to get a copy of the db and data and would like to put this on my
db at home.

How is this possible?

Check out the [mysqldump] utility that comes with your myslql/linux.
This will let you output the sql text that will create the database, all
it's tables and indices, and insert all the data. You will:

1) mysqldump -u{usr} -p{pwd} {dbname} > sql.txt # create the text
dump
2) Move sql.txt to your local (windows) computer
3) mysql -u{usr} -p{pwd} < sql.txt

I don't *think* you need to sweat the Linux/Microsoft <lf>/<cr><lf> line
termination thingy since this should all be just whitespace to MySQL. My
knowledge of the MS side of things is getting shakey. Hopefully, someone
else will jump in if I missed something.

Thomas Bartkus

[Thomas Bartkus]

"Manny" <ma******@hotmail.com> wrote in message
news:3e*************************@posting.google.co m...

My website uses php/mysql/linux and is hosted by a local web-hosting
company. I access the db via cpanel/phpmyadmin and currently perform
all testing and changes on the live db and website ( not good!).

I would like a copy of the db on my own machine at home so I can test
locally rather than on the live db.
I have successfully installed mysql at home (on windows) and now I'd
like to get a copy of the db and data and would like to put this on my
db at home.

How is this possible?

Check out the [mysqldump] utility that comes with your myslql/linux.
This will let you output the sql text that will create the database, all
it's tables and indices, and insert all the data. You will:

1) mysqldump -u{usr} -p{pwd} {dbname} > sql.txt # create the text
dump
2) Move sql.txt to your local (windows) computer
3) mysql -u{usr} -p{pwd} < sql.txt

I don't *think* you need to sweat the Linux/Microsoft <lf>/<cr><lf> line
termination thingy since this should all be just whitespace to MySQL. My
knowledge of the MS side of things is getting shakey. Hopefully, someone
else will jump in if I missed something.

Thomas Bartkus

[Manny]

"Thomas Bartkus" <to*@dtsam.com> wrote in message news:<RI********************@telcove.net>...

I don't *think* you need to sweat the Linux/Microsoft <lf>/<cr><lf> line
termination thingy since this should all be just whitespace to MySQL. My
knowledge of the MS side of things is getting shakey. Hopefully, someone
else will jump in if I missed something.
Thomas Bartkus

Hi,

I do not have access to the linux server therefore cannot perform any
command line queries. Can I create a copy of a DB via phpmyadmin?
Also I would like to backup the db as well - is this possible via
phymyadmin also - or is this something I need to request from my
hoster?

Thanks

[Thomas Bartkus]

"Manny" <ma******@hotmail.com> wrote in message
news:3e**************************@posting.google.c om...

"Thomas Bartkus" <to*@dtsam.com> wrote in message news:<RI********************@telcove.net>...
I do not have access to the linux server therefore cannot perform any
command line queries. Can I create a copy of a DB via phpmyadmin?
I don't know! Someone who knows phpmyadmin will have to chime in.
Also I would like to backup the db as well - is this possible via
phymyadmin also - or is this something I need to request from my
hoster?

Hard to believe your hoster won't provide you with a shell account where you
can do a mysqldump.
Are you working in MS Windows?
If so.
You can link tables to the Linux/MySQL in Access and do
CREATE TABLE {mysql_tbl_backup}
SELECT *
FROM {mysql_linked_table}
This will create a table+data backup on your local windows computer as an
Access .mdb file. Note that this will not copy your indices.

Or you can look for a windows/MySQL client like MySQL-Front which I believe
will allow you to copy mysql tables
http://www.mysql-front.com/
- there are others.

Thomas Bartkus

[swdev2]

Hi - are you a programmer ? [I AM]
I Do this kind o stuff all the time for my clients
utilizing VFP and some tools I wrote .
For Example - I have 11 clients that use LunarPages Hosting - and
they have no shell access - so they have to 'do things' with the
myPhpAdmin thingie [usually] and 'insert from file' is not enabled for them
somehow -
so what I did was to write utils in VFP that accesses the mysql db's via
odbc ..
For LunarPages - its a bit weird each time - you have to get the machine
name of the
client workstation and put that in the db access security area .

if you need further assistance - contact me at mysql at efgroup dot net .
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting
mySql / VFP / MS-SQL

"Manny" <ma******@hotmail.com> wrote in message
news:3e*************************@posting.google.co m...

My website uses php/mysql/linux and is hosted by a local web-hosting
company. I access the db via cpanel/phpmyadmin and currently perform
all testing and changes on the live db and website ( not good!).

I would like a copy of the db on my own machine at home so I can test
locally rather than on the live db.
I have successfully installed mysql at home (on windows) and now I'd
like to get a copy of the db and data and would like to put this on my
db at home.

How is this possible?

Thanks in advance.
Manny

[Good Man]

ma******@hotmail.com (Manny) wrote in news:3e1d3163.0501240242.2de2c45
@posting.google.com:

My website uses php/mysql/linux and is hosted by a local web-hosting
company. I access the db via cpanel/phpmyadmin and currently perform
all testing and changes on the live db and website ( not good!).

I would like a copy of the db on my own machine at home so I can test
locally rather than on the live db.
I have successfully installed mysql at home (on windows) and now I'd
like to get a copy of the db and data and would like to put this on my
db at home.

How is this possible?

Thanks in advance.
Manny

You "dump" the database to a text file. In the PHPMyAdmin screen, go to
"Export"... select all the tables, check the "complete inserts" box, and
save the file (your browser will prompt you to save the file).... call it
"whatever.sql" or "whatever.txt"

throw it into your "mysql/bin" directory, then go to a command prompt in
that directory, type:

mysql -u USERNAME -p < whatever.sql

you will be prompted for your password, and the database will then be
created.
depending on the dump file, you may have to create your database before
doing the dump.