469,299 Members | 2,050 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

Archived Dump of MySQL Database

We are planning on moving to a different server and was wondering if
there was a way to make an archived dump of the database?

If so, how would one go about doing such a thing.

Thanks,
Ryan
Jul 19 '05 #1
10 2201
Ryan wrote:
We are planning on moving to a different server and was wondering if
there was a way to make an archived dump of the database?

If so, how would one go about doing such a thing.


See if these fill your needs:

http://www.mysql.com/doc/en/mysqldump.html

http://www.mysql.com/doc/en/mysqlhotcopy.html

http://www.mysql.com/doc/en/mysqlimport.html

Jul 19 '05 #2
On 8 Jan 2004 08:47:32 -0800, in mailing.database.mysql
ki************@yahoo.com (Ryan) wrote:
| We are planning on moving to a different server and was wondering if
| there was a way to make an archived dump of the database?
|
| If so, how would one go about doing such a thing.
|
| Thanks,
| Ryan

Use mysqldump - found in the bin folder.
mysqldump -B [database] -e -F -f > [filename]

This will dump the table create statements and its data to a text
file. Use mysqldump --help to see full list of options available.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 19 '05 #3
Ryan wrote:
We are planning on moving to a different server and was wondering if
there was a way to make an archived dump of the database?

If so, how would one go about doing such a thing.


See if these fill your needs:

http://www.mysql.com/doc/en/mysqldump.html

http://www.mysql.com/doc/en/mysqlhotcopy.html

http://www.mysql.com/doc/en/mysqlimport.html

Jul 19 '05 #4
On 8 Jan 2004 08:47:32 -0800, in mailing.database.mysql
ki************@yahoo.com (Ryan) wrote:
| We are planning on moving to a different server and was wondering if
| there was a way to make an archived dump of the database?
|
| If so, how would one go about doing such a thing.
|
| Thanks,
| Ryan

Use mysqldump - found in the bin folder.
mysqldump -B [database] -e -F -f > [filename]

This will dump the table create statements and its data to a text
file. Use mysqldump --help to see full list of options available.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 19 '05 #5
Jeff North <jn****@yourpantsbigpond.net.au> wrote in message news:<ei********************************@4ax.com>. ..
On 8 Jan 2004 08:47:32 -0800, in mailing.database.mysql
ki************@yahoo.com (Ryan) wrote:
| We are planning on moving to a different server and was wondering if
| there was a way to make an archived dump of the database?
|
| If so, how would one go about doing such a thing.
|
| Thanks,
| Ryan

Use mysqldump - found in the bin folder.
mysqldump -B [database] -e -F -f > [filename]

This will dump the table create statements and its data to a text
file. Use mysqldump --help to see full list of options available.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

Thanks for the help. I should have mentioned this earlier, it slipped
my mind at the time, but I don't have direct access to the server.
All of the input was used viw PHP coding.

Is there a way for it to be done using PHP scripting?
Jul 19 '05 #6
On 9 Jan 2004 22:02:06 -0800, in mailing.database.mysql
ki************@yahoo.com (Ryan) wrote:
| Jeff North <jn****@yourpantsbigpond.net.au> wrote in message news:<ei********************************@4ax.com>. ..
| > On 8 Jan 2004 08:47:32 -0800, in mailing.database.mysql
| > ki************@yahoo.com (Ryan) wrote:
| >
| > >| We are planning on moving to a different server and was wondering if
| > >| there was a way to make an archived dump of the database?
| > >|
| > >| If so, how would one go about doing such a thing.
| > >|
| > >| Thanks,
| > >| Ryan
| > Use mysqldump - found in the bin folder.
| > mysqldump -B [database] -e -F -f > [filename]
| >
| > This will dump the table create statements and its data to a text
| > file. Use mysqldump --help to see full list of options available.
|
| Thanks for the help. I should have mentioned this earlier, it slipped
| my mind at the time, but I don't have direct access to the server.
| All of the input was used viw PHP coding.
|
| Is there a way for it to be done using PHP scripting?


Grab yourself a copy of phpmyadmin from:
http://www.phpmyadmin.net/

You can do all that from a web browser. If you can't install this app
on the server then see if your ISP has this already installed an what
actions you need to take.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 19 '05 #7
Jeff North <jn****@yourpantsbigpond.net.au> wrote in message news:<ei********************************@4ax.com>. ..
On 8 Jan 2004 08:47:32 -0800, in mailing.database.mysql
ki************@yahoo.com (Ryan) wrote:
| We are planning on moving to a different server and was wondering if
| there was a way to make an archived dump of the database?
|
| If so, how would one go about doing such a thing.
|
| Thanks,
| Ryan

Use mysqldump - found in the bin folder.
mysqldump -B [database] -e -F -f > [filename]

This will dump the table create statements and its data to a text
file. Use mysqldump --help to see full list of options available.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

Thanks for the help. I should have mentioned this earlier, it slipped
my mind at the time, but I don't have direct access to the server.
All of the input was used viw PHP coding.

Is there a way for it to be done using PHP scripting?
Jul 19 '05 #8
Jeff North <jn****@yourpantsbigpond.net.au> wrote in message news:<ei********************************@4ax.com>. ..
On 8 Jan 2004 08:47:32 -0800, in mailing.database.mysql
ki************@yahoo.com (Ryan) wrote:
| We are planning on moving to a different server and was wondering if
| there was a way to make an archived dump of the database?
|
| If so, how would one go about doing such a thing.
|
| Thanks,
| Ryan

Use mysqldump - found in the bin folder.
mysqldump -B [database] -e -F -f > [filename]

This will dump the table create statements and its data to a text
file. Use mysqldump --help to see full list of options available.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------

Thanks for the help. I should have mentioned this earlier, it slipped
my mind at the time, but I don't have direct access to the server.
All of the input was used viw PHP coding.

Is there a way for it to be done using PHP scripting?
Jul 19 '05 #9
On 9 Jan 2004 22:02:06 -0800, in mailing.database.mysql
ki************@yahoo.com (Ryan) wrote:
| Jeff North <jn****@yourpantsbigpond.net.au> wrote in message news:<ei********************************@4ax.com>. ..
| > On 8 Jan 2004 08:47:32 -0800, in mailing.database.mysql
| > ki************@yahoo.com (Ryan) wrote:
| >
| > >| We are planning on moving to a different server and was wondering if
| > >| there was a way to make an archived dump of the database?
| > >|
| > >| If so, how would one go about doing such a thing.
| > >|
| > >| Thanks,
| > >| Ryan
| > Use mysqldump - found in the bin folder.
| > mysqldump -B [database] -e -F -f > [filename]
| >
| > This will dump the table create statements and its data to a text
| > file. Use mysqldump --help to see full list of options available.
|
| Thanks for the help. I should have mentioned this earlier, it slipped
| my mind at the time, but I don't have direct access to the server.
| All of the input was used viw PHP coding.
|
| Is there a way for it to be done using PHP scripting?


Grab yourself a copy of phpmyadmin from:
http://www.phpmyadmin.net/

You can do all that from a web browser. If you can't install this app
on the server then see if your ISP has this already installed an what
actions you need to take.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 19 '05 #10
On 9 Jan 2004 22:02:06 -0800, in mailing.database.mysql
ki************@yahoo.com (Ryan) wrote:
| Jeff North <jn****@yourpantsbigpond.net.au> wrote in message news:<ei********************************@4ax.com>. ..
| > On 8 Jan 2004 08:47:32 -0800, in mailing.database.mysql
| > ki************@yahoo.com (Ryan) wrote:
| >
| > >| We are planning on moving to a different server and was wondering if
| > >| there was a way to make an archived dump of the database?
| > >|
| > >| If so, how would one go about doing such a thing.
| > >|
| > >| Thanks,
| > >| Ryan
| > Use mysqldump - found in the bin folder.
| > mysqldump -B [database] -e -F -f > [filename]
| >
| > This will dump the table create statements and its data to a text
| > file. Use mysqldump --help to see full list of options available.
|
| Thanks for the help. I should have mentioned this earlier, it slipped
| my mind at the time, but I don't have direct access to the server.
| All of the input was used viw PHP coding.
|
| Is there a way for it to be done using PHP scripting?


Grab yourself a copy of phpmyadmin from:
http://www.phpmyadmin.net/

You can do all that from a web browser. If you can't install this app
on the server then see if your ISP has this already installed an what
actions you need to take.
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 19 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Ryan | last post: by
6 posts views Thread by Eric Robinson | last post: by
1 post views Thread by Brian Sadler | last post: by
1 post views Thread by Raquel | last post: by
4 posts views Thread by Robert Blackwell | last post: by
3 posts views Thread by Ike | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.