Yes I had thought I should use tools to copy, but I have had problems with
mysqldump. I successfully created a dump file, but when I execute this file on
an empty database I got:
C:\xampp\xampp\mysql\bin>mysql -uroot db2 < test1.txtERROR 1064 at line
54: You have an error in your SQL syntax. C
ECTED] [mailto:[EMAIL PROTECTED]
Sent: samedi 30 avril 2005 00:30
To: mysql@lists.mysql.com
Subject: Newbie Q - Re: Copying databases
I am having to operating MySQL 4.0.18, I had heared that I could copy a
db folder out of the mysql/data folder to the same folder on a different
machine running its own
I am having to operating MySQL 4.0.18, I had heared that I could copy a db
folder out of the mysql/data folder to the same folder on a different machine
running its own local host server and that server would have a copy of the
database. HOWEVER, o some occasions this seemed to work Ok, and on
You could try changing the priority of your inserts using INSERT LOW PRIORITY
See: http://www.mysql.com/doc/en/INSERT.html
This will give the selects priority over the inserts, as the table becomes
free, the insert will happen.
Also, look at this:
http://www.mysql.com/doc/en/Insert_speed.html
Hi Bryan,
Start with this:
% mysqldump --help
From: Bryan McCloskey <[EMAIL PROTECTED]>
> ...make a copy of my database
% mysqldump --opt database_one > copy.sql
> ...data itself is not important...
> ...better if I could _not_ copy the thousands of rows...
% mysqldump --opt -d data
ok, fyi, the below worked fine.
now...
as readers here may know, this db newbie had problems getting MySQL
up and running -much like the other person with pwd problems. i
erased the drive (OS X pb/Tenon iTools), reinstalled and all is well,
it even starts itself.
> last night i took a MySQL database (a folder i got out of the
> MySQL/data folder) home and copied into the data folder on my
> machine, is this ok?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_3_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www
