Backup/Restore MySQL databases.

Thomas Bartkus

Is it safe to say that restoring the [/usr/local/myql/data] directory from a
backup would that restore all database data and structure? All usr/pwd and
GRANT info?

Thomas Bartkus

Jul 20 '05 #1

Subscribe Post Reply

2125

steve

"Thomas Bartkus" wrote:

Is it safe to say that restoring the [/usr/local/myql/data] directory from a
backup would that restore all database data and structure? All
usr/pwd and
GRANT info?

Thomas Bartkus

You would be able to restore the data as you state. You would then
have to run an sql repair on all tables, as mysql would not be in sync
with those tables. I have heard that sometimes repair may not work,
but I have not had problems with this personally.

I don’t know about the privilages. I am talking about restoring
databases one at a time.

--
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-Backup...ict125574.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=433751

Jul 20 '05 #2

steve

"Thomas Bartkus" wrote:

Is it safe to say that restoring the [/usr/local/myql/data] directory from a
backup would that restore all database data and structure? All
usr/pwd and
GRANT info?

Thomas Bartkus

Jul 20 '05 #3

Similar topics

MYSQL Backup & Restore using PHP ?

by: James | last post by:

HI, I'm looking for a script that will allow users/admins to have a one click backup solution for a MYSQL Database.. 'BACK DATABASE' button, click and its done... The a restore option, that...

PHP

InnoDB backup and restore

by: Reuben Pearse | last post by:

Hi all, I've just converted the tables in a big database (approx 27 million records) from MyISAM to InnoDB. When I was using MyISAM I backed up the database by stopping MySQL and then copying...

MySQL Database

mysql backup query

by: Elaine | last post by:

hi Hopefully this is simple enough. I'm running 3.23 and 4.1.7 mysql databases. I run a /usr/bin/mysqlhotcopy backup on a specific database name , and copy my.cnf and ib* files to the backup...

MySQL Database

Restoring select databases/tables from an --all-databases backup

by: Raffi | last post by:

I use the --all-databases switch to backup my entire database. Sometimes there's a need to restore individual databases or tables form the backup file. What command should I use for this? ...

MySQL Database

Can I backup my databases by copying "data" folder instead of mysqldump?

by: 21novembre | last post by:

Hi all, I made a question several days before to describe my strange trouble of mysqldump. But I still can't figour it out. Well, I just want to ask another question whether I could just backup...

MySQL Database

Backup Strategies

by: Rajesh Kapur | last post by:

I have about 20 databases in a single MySQL instance running 4.0.21 on RHEL3. I have a healthy mix of MyISAM and InnoDB tables. Howerver these two types do not mix within a single database. A...

MySQL Database

mysql backup and restore for 4.1.x

by: newman | last post by:

Dear all, I have mysql 4.1.11 on my current server, i need my database restore another server.. (another server mysql version is 4.1.11 same.) And now... I just created new my database to new...

MySQL Database

MySQL backup tools

by: deepstar | last post by:

Hello I have a rather large database (about 102 megabytes when dumped to an SQL file) and need advice on backup software for MySql databases. So far I've only tried Navicat and it takes about 30...

MySQL Database

db2 UDB backup using COMPRESS option

by: zgh1970 | last post by:

Hi, Friends, default DB2 compression library. I am wondering if this option will have any new restriction on RESTORE in the following. (Can I used that backup imsage for restore at the...

DB2 Database

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...

General

PHP Curl Not wanting to connect to localhost.

by: Matthew3360 | last post by:

Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...

PHP

FPGA Question

by: Oralloy | last post by:

Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...

General

One of the easiest ways to set the background color of Excel documents in Java

by: Carina712 | last post by:

Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...

General

Mastering Python: A Versatile Programming Language for All

by: Rahul1995seven | last post by:

Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...

General

Datasheet Form, iterate through records

by: Johno34 | last post by:

I have this click event on my form. It speaks to a Datasheet Subform Private Sub Command260_Click() Dim r As DAO.Recordset Set r = Form_frmABCD.Form.RecordsetClone r.MoveFirst Do If...

Microsoft Access / VBA

Hide Labels depending on checkbox value

by: ezappsrUS | last post by:

Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...

Microsoft Access / VBA

hello, Is there code or static lib for hook swapchain present?

by: jack2019x | last post by:

hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.

C / C++

Handling .click() in the Safari browser

by: DizelArs | last post by:

Hi all) Faced with a problem, element.click() event doesn't work in Safari browser. Tried various tricks like emulating touch event through a function: let clickEvent = new Event('click', {...

Javascript