Hello Ben, all!
Ben Burford wrote:
Hello,
This is my first message, I'm an absolute beginner in Mysql. I did a defaul
t installation of version 3.23.58 on RH Linux AS3.0. [[...]]
I will not comment on the backup issue, that has been done already.
However, I _strongly_ urge you to upgrade
mysqldump --verbose --add_drop-table --all-databases > backup_06082006.sql
or
mysql --add_drop-table < backup_06082006.sql
or maybe
mysql < --add_drop-table backup_06082006.sql
mysqldump --opt...
This will add DROP TABLE .. IF EXISTS to a dump.
--
MySQL General Mailing List
For list
On 6/9/06, Ben Burford <[EMAIL PROTECTED]> wrote:
Hello,
This is my first message, I'm an absolute beginner in Mysql. I did a defaul
t installation of version 3.23.58 on RH Linux AS3.0. I want to be a able to
do a backup and a restore.
The user's manual says:
5.9.2.1 Backup Policy
The follow
Hi Eugene,
Good to hear from you. Should I use this on the creation or the restore? A
s in:
mysqldump --verbose --add_drop-table --all-databases > backup_06082006.sql
or
mysql --add_drop-table < backup_06082006.sql
or maybe
mysql < --add_drop-table backup_06082006.sql
or maybe something
Ben Burford wrote:
Hello,
Do I need to delete the table 'Indian'??
Try --add_drop-table option
man mysqldump
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
This is my first message, I'm an absolute beginner in Mysql. I did a defaul
t installation of version 3.23.58 on RH Linux AS3.0. I want to be a able to
do a backup and a restore.
The user's manual says:
5.9.2.1 Backup Policy
The following command makes a full backup . . :
mysqldump --si
latin5_turkish_ci;
because our database and tables uses latin5 and turkish_ci collation.
How can i get correct backup and restore for this character sets? example;
mysqldump -uUSER -pDBNAME > /path/backup.sql
and restore;
mysql -uUSER -pDBNAME < /path/backup.sql
is this correct for me?
OR
mys
b>mydbfile
> > or restore a database in a query like below ?
> > mysql.exe -h 192.168.0.1 -u root -p -C mydb >
> > Then we can do backup and restore in GUI mode without call
> > mysqldump.e
> Could we do a database dump/backup in a query like below ?
> mysqldump.exe --default-character-set=gb2312 --opt --host 192.168.0.1 -u
> root -p -C mydb>mydbfile
> or restore a database in a query like below ?
> mysql.exe -h 192.168.0.1 -u root -p -C mydb
> Then we can do
kup and restore in GUI mode without call
mysqldump.exe,mysql.exe in character mode .
Best regard!
Shuming Wang
_
Express yourself instantly with MSN Messenger! Download today it's
FREE! http://messenger.msn.click-ur
Hi,
Could we do a database dump/backup in a query like below ?
mysqldump.exe --default-character-set=gb2312 --opt --host 192.168.0.1 -u
root -p -C mydb>mydbfile
or restore a database in a query like below ?
mysql.exe -h 192.168.0.1 -u root -p -C mydbThen we can do backup and restore in
Hi,
I have two identical machines in terms of OS and software installed (more info
at the end of the message).
I need to dump a database on the first machine and restore it on the second
one.
Here is step by step what I'm doing.
==> on server1
$mysqldump cerberus_database > cerberus_database-
I prefder to use a FREE GUI like SQLyog found at
http://www.webyog.com
Karam
--- Gary Richardson <[EMAIL PROTECTED]> wrote:
> try mysqldump -keq SDN > SDN.sql
>
> Then you can import it on another instance using
> mysql -u root
> new_instance < SDN.sql
>
> On 5/5/05, zlf <[EMAIL PROTECTED]> wro
try mysqldump -keq SDN > SDN.sql
Then you can import it on another instance using mysql -u root
new_instance < SDN.sql
On 5/5/05, zlf <[EMAIL PROTECTED]> wrote:
> Hi all,
> I have installed a MySQL5.0 instance on Windows. And then created a
> database( named 'SDN' ). Now I want to move this
Hi all,
I have installed a MySQL5.0 instance on Windows. And then created a
database( named 'SDN' ). Now I want to move this database to another
MySQL5.0 envirnment on Linux.
How can I make it. Thx
zlf
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
[EMAIL PROTECTED] wrote:
Hi All,
Mysqldump -h host name -u username -p password --databases > dump.dmp
My doubts are as follows.
1. How to take the backup and restore from the client machine using
ODBC?
mysqldump is a command line utility for making backups. You will have to
exec (i
Hi All,
I need to backup and restore MySQL database using ODBC from my client
machine. My database is in the remote server.
I am building my backup command using C program.
Example: My backup will have the following.
Mysqldump -h host name -u username -p password --databases
Have you looked at mysqldump function?
-Original Message-
From: Alex Shi [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 1:36 PM
To: [EMAIL PROTECTED]
Subject: Backup and Restore
Hello,
I have a question regarding to table backup and restore. Suppose
we have a table of
Hello,
I have a question regarding to table backup and restore. Suppose
we have a table of sales waste book. Now I need to backup data
within a certain period of time (from date1 to date2) from the table,
and after backup the data should be deleted from the table. Also
the backuped data can be
Hi
I am reposting this just in case someone who would be able to assist me did
not see it first time around.
Thanks
Deon.
I am currently putting together a backup system for our MySQL server. The
way I want to do this is to make use of mysqldump to perform the backup and
have the binary log (o
Hi There
I have only just subscribed to this list - thank you in advance for any
assistance.
I am currently putting together a backup system for our MySQL server. The
way I want to do this is to make use of mysqldump to perform the backup and
have the binary log (on a different disk to my datab
You dont need a script or command to restore the database, mysqlhotcopy
just creates a copy of your database files (.MYI, etc.) in the
/pathToTheBackupDirectory/. It basicaly performs the same function as the
unix command cp, only it does the necessary locking, etc.
John Barton
Unix Systems Admin
Hi,
If I use "mysqlhotcopy database/pathToTheBackupDirectory/" to backup the
whole database, what's the script/command to restore it?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
Sorry if this is a little late- but at Abriasoft we are currently developing a tool
that can be used for automated backup of your MySQL databases from one or more servers
with the ability to restore from the backups in the event that you need to.
Our tool uses a C daemon and a php web interface
24 matches
Mail list logo