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
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
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]
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
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
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
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
mysqldump
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 mydbmydbfile
or restore a database in a query like below ?
mysql.exe -h 192.168.0.1 -u root -p -C mydbmydbfile
Then we can do backup and restore
do backup 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-url.com/go
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 mydbmydbfile
or restore a database in a query like below ?
mysql.exe -h 192.168.0.1 -u root -p -C mydbmydbfile
Then we can do backup and restore
below ?
mysql.exe -h 192.168.0.1 -u root -p -C mydbmydbfile
Then we can do backup and restore in GUI mode without call
mysqldump.exe,mysql.exe in character mode .
Best regard!
Shuming Wang
_
Express yourself instantly
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
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
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
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] wrote:
Hi
[EMAIL PROTECTED] wrote:
Hi All,
Mysqldump -h host name -u username -p password --databases database
name 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
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 database
:syntax error so i usually have to
edit/comment out those lines so backup tablename is faster and works better
usually...
- Original Message -
From: Riaan Oberholzer [EMAIL PROTECTED]
To: Andy B [EMAIL PROTECTED]
Sent: Tuesday, April 13, 2004 2:20 AM
Subject: Re: backup table/restore
hi...
i have a server where there are 5 tables inside a database. i was wondering
if i did the following command from inside a script:
backup table dbname.tablename to /home/users/my_dir/
then with a different script gzip/tar them, after gzipped ftp them to my
test server into say
At 20:23 -0400 4/12/04, Andy B wrote:
hi...
i have a server where there are 5 tables inside a database. i was wondering
if i did the following command from inside a script:
backup table dbname.tablename to /home/users/my_dir/
then with a different script gzip/tar them, after gzipped ftp them to
in this world,
those who understand binary and those who don't (Unknown)
- Original Message -
From: Taylor Lewick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 3:45 PM
Subject: Re: Backup, move, restore..?
OKay, thanks, any idea if something has to be done differently
: Taylor Lewick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 8:49 PM
Subject: Backup, move, restore..?
Hi all. I am needing to do a backup of two smalldatabases, both live on
the same server and under the same Mysql binary installation...
I would like to back them up
Hi all. I am needing to do a backup of two smalldatabases, both live on
the same server and under the same Mysql binary installation...
I would like to back them up, dump them into a file(s), make my move,
install the same database, and then restore/load this dumped
information
back into the new
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
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
a table is backed up, data is modified in that
table - thus adding the entry to the binary log - with the result that the
modification is already in my backup, as well as in the log. I then, after
a failure, restore my backup, replay my log and the modification is
duplicated.
A second question which may
is modified in that
table - thus adding the entry to the binary log - with the result that the
modification is already in my backup, as well as in the log. I then, after
a failure, restore my backup, replay my log and the modification is
duplicated.
A second question which may answer my first
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
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
to the list, use the e-mail address above, and let us know if you
are interested in x86 linux or Windows.
On Thursday, January 4, 2001, at 12:43 PM, Ashish Shah wrote:
Hi all,
How do I backup/restore mysql?
Any help would be appriciated.
Thanks.
=
Ashish
Toronto, Canada
30 matches
Mail list logo