473,326 Members | 2,147 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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 2408
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Ryan | last post by:
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
6
by: Eric Robinson | last post by:
Our database just slowed down radically. Certain queries drive CPU utilization through the roof. This happened once before, and the technican simply dumped the data to disk and then played it back...
1
by: Brian Sadler | last post by:
Does anyone know where I can find information on how to setup my shell in unix/linux to allow me to restore a database from an sql dump... Example... I have a database on 83200.mysql.com ...
1
by: Raquel | last post by:
Ok, so these are the two pieces of information regarding the location of archived logs during a rollforward recovery in a recoverable database: 1. OVERFLOWLOGPATH configuration parameter can...
0
by: Takpol | last post by:
Hello, I have several archived filegroups that have data in them partitioned based on the date. These filegroups have been removed from database after archival. For example two months ago....
4
by: Robert Blackwell | last post by:
A while ago I had some help from here to make a batch file that would dump my db. Everything was working just fine until 2 days ago and I just found out. I checked my backup folder and found...
3
by: Ike | last post by:
Here's a dumb question, but I am unable to find the relevant spot in the online docs, and am coming to the group asking my (pathetically) little dumb question (which I should know the answer to!) ...
3
by: pechar | last post by:
Hi all, I am planning to create a windows application, which is meant to retrieve the sql dump of a mysql database. What I need is the structure and the data as well. You might ask why create...
1
by: raamay | last post by:
I want to run the mysql generated dump values of a database through a textarea in php. I am copying the whole dump code in a textarea and then let the php run the entire code. But here the problem is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.