database.txt.
On Sat, 10 Mar 2001, Kenneth Karen Brill wrote:
How do I move a MySQL database to a new computer?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
How do I move a MySQL database to a new computer?
Keneth wrote:
"When I try to dump sql database it gives me some errors 1.Error 1045
mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045:
Access denied for user: 'accp@localhost' (Using pass word: NO) "
can you help?
with best regards,
Keneth
Read the manual, read
Does anyone know how to convert a FreeBSD UNIX MYSql database to Windows
NT/2000 MYSql Database?
Thanks,
Tom Flanagan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
In the last episode (Mar 08), Tom Flanagan said:
Does anyone know how to convert a FreeBSD UNIX MYSql database to Windows
NT/2000 MYSql Database?
Just copy the files over to the new machine. No conversion necessary.
--
Dan Nelson
[EMAIL PROTECTED
Tom Flanagan wrote:
Does anyone know how to convert a FreeBSD UNIX MYSql database to Windows
NT/2000 MYSql Database?
Thanks,
Tom Flanagan
If you are using MyISAM tables (3.23.x) you can simply copy them from
one computer to the other. If you are using ISAM tables like in
3.22 you
On 28.02.2001 05:58:33 ?US-ASCII?Q?Fabio_Ottolini?= wrote:
mysqldump "spits" not only table structures but data also. When you use
mysql to import data it will first attempt to create the table and then load
its values. If your table's got AUTO_INCREMENT set it will work fine after
On 28.02.2001 19:51:13 Gerald L. Clark wrote:
In the dump, the autoincrement columns will have their actual values,
not 0.
Yes, correct - and if the actual value is 0, it will contain just this. And
inserting a row with the col set to 0, will change the column value.
TRY IT!
Try using mysqldump.
BR,
Fbio Ottolini
-Original Message-
From: Keneth [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 28, 2003 5:06 AM
To: [EMAIL PROTECTED]
Subject: how to backup mySQL database?
Anyone know how to backup mySQL database?
with best regards,
TOM
t;Fbio Ottolini" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 4:26 AM
Subject: RE: how to backup mySQL database?
Try using mysqldump.
BR,
Fbio Ottolini
-Original Message-
From: Keneth [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 28, 2003 5:06 AM
On 28.02.2001 21:26:17 ?iso-8859-1?Q?F=E1bio_Ottolini?= wrote:
Try using mysqldump.
This won't work always! For instance, I have a table that has a auto_increment
INT column in it. Storing a row with this column set to 0 (zero), will add this
row just fine. But now the row will not have
On 28.04.2003 10:55:50 Keneth wrote:
"When I try to dump sql database it gives me some errors 1.Error 1045
mysqldump --opt database backup-accp.sql mysqldump: Got error: 1045:
Access denied for user: 'accp@localhost' (Using pass word: NO) "
You did not specify the username and password on
[EMAIL PROTECTED] wrote:
On 28.02.2001 21:26:17 ?iso-8859-1?Q?F=E1bio_Ottolini?= wrote:
Try using mysqldump.
This won't work always! For instance, I have a table that has a auto_increment
INT column in it. Storing a row with this column set to 0 (zero), will add this
row just fine.
o Ottolini
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Gerald L. Clark
Sent: Wednesday, February 28, 2001 12:04 PM
To: [EMAIL PROTECTED]
Cc: Fabio Ottolini; [EMAIL PROTECTED]
Subject: Re: Antwort: RE: how to backup mySQL database?
[EMAIL PROTEC
[EMAIL PROTECTED] wrote:
On 28.02.2001 16:03:57 Gerald L. Clark wrote:
But the dump who't have it set to zero, so it will reload with its
proper value.
No, in the dump the column will be set to zero, but since "INSERT INTO Tbl
(AutoCol) VALUES (0)" means that AutoCol should be set to
how to backup mySQL database?
with best regards,
TOM
Posted via Project Horizon
http://www.projecthorizon.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
:21 a.m.
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: how to backup mySQL database?
This is the way i do it:
- write a script that will run mysqldump on the database of choice and then
pipe the result though gzip (this is only to reduce the size)
- the script also copies the new backup
Anyone know how to backup mySQL database?
with best regards,
TOM
Hi,
I have a MySql database with customer information which is to be exported
to an oracle database. I was wondering if someone could tell me the easiest
way of doing this. Is there any such applications which look after the
exporting of the data from the MySql database and importing to the new
Joe.O'[EMAIL PROTECTED] (Joe.O'[EMAIL PROTECTED]) writes:
I have a MySql database with customer information which is to be exported
to an oracle database. I was wondering if someone could tell me the easiest
way of doing this. Is there any such applications which look after the
exporting
I don't think that's possible. Mind you, they won't be able to do much
anyway as they didn't supply any passwords.
- Original Message -
From: "lkeeton" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 12, 2001 23:30
Subject: Want to Deny Access into MySql Dat
GRANT. Then import the text file(s) into the new Linux
database.
G. Jensen
- Original Message -
From: "Erick Papadakis" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 11, 2001 10:03 AM
Subject: reproducing windows mysql database on a linux box?
hello,
i ve b
Erick:
Do not try to copy the database files themselves. Instead use mysqldump to
dump the structure and contents to text files, which you can easily copy
across the network from your Windoze to Linux.
My advice is to create an empty database on the Linux machine,
and set your
get with computer
journals: put it into your CD-drive and open it with your browser on any
operating system (at least Linux, Mac and Windows). Is there any tool to
produce such a CD from a MySQL database, so that the user can browse
through it and also search for specific items without installing any
and Windows). Is there any tool to
produce such a CD from a MySQL database, so that the user can browse
through it and also search for specific items without installing any new
software on the system? Of course, MySQL is free and so we could put it on
the CD or ask the people to install it over the net
I would like to know If there are webhosters that accept connections
to hosted MySQL databases
from other domains than localhost (via php) ?
I want to manage MySQL database directly from anywhere with home-made tools.
Thanks
--
--
Stphane Pinel
39, Rue du
701 - 726 of 726 matches
Mail list logo