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
nk around with the GUI's, but the std command line tools will get
you there just fine... :-)
-Original Message-
From: Tim Winters [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 3:09 PM
To: [EMAIL PROTECTED]
Subject: RE: NEWBIE QUESTION: Copying Databases from local to s
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: June 4, 2003 3:35 PM
To: [EMAIL PROTECTED]
Subject: Re: NEWBIE QUESTION: Copying Databases from local to server
I'd suggest using phpMyAdmin on the remote server for your setup.
Depending on
the application, i
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, 04 June, 2003 00:49
Subject: NEWBIE QUESTION: Copying Databases from local to server
Hello,
I have several databases currently located on my local machine that I need
to copy to a remote server.
Con someone explain the process and
Tim,
> I have several databases currently located on my local machine that I need
> to copy to a remote server.
You can dump the contents of your databases with mysqldump, and load
those contents on your other server, using the mysql client program or
another tool like phpMyAdmin. You can even co
Try to use FTP to upload them.
--
>Hello,
>
>I have several databases currently located on my local machine that I need
>to copy to a remote server.
>
>Con someone explain the process and details of how this is done?
>
>Thanks,
>
>Tim Winters
>Manager, Creative Deve
Hello,
I have several databases currently located on my local machine that I need
to copy to a remote server.
Con someone explain the process and details of how this is done?
Thanks,
Tim Winters
Manager, Creative Development
Sampling Technologies Incorporated (STI)
[EMAIL PROTECTED]
[EMAIL PROT
-J
-Original Message-
From: Seth Brundle [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 2:01 PM
To: [EMAIL PROTECTED]
Subject: copying databases to avoid insert holdups
I have a MySQL database I will be launching soon which has a search engine
database accesable over DBI
I have a MySQL database I will be launching soon which has a search engine
database accesable over DBI/mod_perl/Apace. It has about 2M records, and is
a 4GB table with 1GB index.
Every day I insert 76k records all at once and delete about another 76k.
While these inserts are happening, the select
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
I am attempting to make a copy of my database, so that I will have one copy
that my scripts in development can tinker with, while the functional version
remains safe and unchanged. However, I am having difficulty figuring out how
to do this. All that is important is that I create a copy of the
Original Message -
>From: <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Sunday, February 11, 2001 7:55 PM
>Subject: copying databases
>
>
>> hi,
>>
>> i'm a stu so don't all the time in the world... who does!
>>
>> l
> 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
hi,
i'm a stu so don't all the time in the world... who does!
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?
unfortunately i cannot simply 'see if it runs' because i am having
those terrible soc
16 matches
Mail list logo
