Swati,
You can also use mysqldump to be part of the mechanism to move the
database(s) from one computer to another. Something like:
Prompt> mysqldump --add-drop-table databasename -uuserid -ppassword | mysql
--host=your.new.host.IP databasename -uuserid -ppassword
-Original Message-
Yes, you can do it like this:
Prompt> mysqldump --add-drop-table --host=source.IP.addr.spec -uuser
-ppassword databasename | mysql -uuser -ppassword
I've found that it helps things if you add --no-data to the source side on
the first pass, then remove that clause and run it again.
Dave
-
If you can mount the Windows partitions under LINUX, you can copy file files
from partition to partition. If that's not possible, you'll have to export
the data under Windows to another location/media, then boot into LINUX and
load the data into your LINUX database.
You can dump the databases fro
In the data directory for MySQL, you should find a file titled
.err. What is the contents of that file?
-Original Message-
From: Hamid Nouri [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 18, 2003 5:07 PM
To: [EMAIL PROTECTED]
Subject: I can't start mysqld
Hi there
I have a problem
Are you attempting any sort of editing of the exported file?
We routinely dump our production database, which includes several tables
that hold TIF images, with no problems at all. In fact, we'll also transfer
data between servers with a command like:
Mysqldump --add-drop-table -uroot -ppassw
Here's the link to the on-line manual page that will help you.
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
-Original Message-
From: Dan Anderson [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 5:06 PM
To: [EMAIL PROTECTED]
Subject: Getting the value of a row you ju
What machines are you working with at each end? Internal network?
-Original Message-
From: Nitin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 10:19 AM
To: Andy Eastham; Mysql List
Subject: Re: how to export data from multiple tables
any idea, how to export data to a file
I've worked on applications like this one in a court scheduling application.
Since trials can run several days, this was an issue I had to deal with,
too. The solution I set up was to have a table like your "bookings" table,
then have another table containing available time slots for each eligible
You can, via ODBC, connect to MySQL using OpenOffice or Star Office which
would give you a no-cost, or low-cost, option for producing reports from
MySQL. There are a number of execellent web articles about interfacing
either of these with MySQL. Try searching via Google.
-Original Message---
You're going to have to see where the files were installed. It was easier
with Red Hat 7.3 because the Kpackage program would tell you where the files
were installed. I don't know how you find that info out with Red Hat 8.0 or
9.0.
-Original Message-
From: Harrell, Roger [mailto:[EMAIL P
Craig,
Errno 13 indicates that you have some permission issues. Check the data
directories you've set up to make sure that they are owned by the user/group
mysql.
-Original Message-
From: Craig A. Finseth [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 1:42 PM
To: [EMAIL
Did you set up a my.ini file in your Windows directory? If so, what is in
the file?
-Original Message-
From: Scott D. Spiegler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 10:24 AM
To: Christensen, Dave; '[EMAIL PROTECTED]';
'[EMAIL PROTECTED]'
Su
Scott,
You should be able to find a file titled 'mysql.err' in your data directory.
This file will contain information that should help you get started.
-Original Message-
From: Scott D. Spiegler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003 6:59 AM
To: [EMAIL PROTECTED]
This may seem like a stupid question, but I haven't been able to track down
an answer yet. We're going to try to access a remote MySQL server that is
protected behind a firewall. I know that we need to open a port, such as
3306, to access the server. My question is whether that port requires TCP
al Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 12:19 PM
To: Christensen, Dave
Cc: '[EMAIL PROTECTED]'
Subject: Re: Odd thing
Christensen, Dave wrote:
>Oops! Sorry. Deleted that 'temp' table and didn't remove it from my
Oops! Sorry. Deleted that 'temp' table and didn't remove it from my script
file.
-Original Message-
From: Christensen, Dave [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 11:34 AM
To: 'Jay Blanchard'; Dickey, Dallas; '[EMAIL PROTECTED]'
Subj
When I run this script file, I receive errors like this:
[EMAIL PROTECTED] work]# ./BackupByTable.bat
mysqldump: Got error: 1146: Table 'AgentAdminDB.MissedPages' doesn't exist
when
doing LOCK TABLES
-Original Message-
From: Christensen, Dave [mailto:[EMAIL PROTECTED]
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
users -uroot -ppano4577 > users.sql
mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB
usertypelookup -uroot -ppano4577 > usertypelookup.sql
+
-Original Message-
From:
Yes, we'd be creating the file on a Windows box, then transferring the file
to either a Samba share or using FTP to the LINUX machine.
-Original Message-
From: Matthew Smith [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 9:54 AM
To: Christensen, Dave; 'Jay Blanchar
: Christensen, Dave; [EMAIL PROTECTED]
Cc: Dickey, Dallas
Subject: RE: Odd thing
[snip]
We're trying to set up some scripts that will run mysqldump to create export
files for each table in a database that can be downloaded to a test server
and reloaded. What's weird is that the files a
The server (our development test server) is running Red Hat 8.0 and Mysql
4.1. The remote test server to which we're trying to transfer data is
running Red Hat 7.3 and Mysql 4.013.
David Christensen
Brokers International, Ltd.
1200 E Main St
PO Box 160
Panora, IA 50216
(800) 362-1097 or (641) 75
We're trying to set up some scripts that will run mysqldump to create export
files for each table in a database that can be downloaded to a test server
and reloaded. What's weird is that the files are created with the "?"
character as the trailing character in the file name and we can't open them
ent: Wednesday, June 11, 2003 5:19 PM
To: Paul DuBois
Cc: Christensen, Dave; '[EMAIL PROTECTED]'
Subject: Re: MySQL 4.1 and MyCC
Paul DuBois wrote:
> At 11:55 -0500 6/11/03, Christensen, Dave wrote:
>
>> I upgraded my test MySQL server yesterday to 4.1 and I'm now
>&
Peter Burden
Cc: Christensen, Dave; '[EMAIL PROTECTED]'
Subject: Re: MySQL 4.1 and MyCC
At 23:18 +0100 6/11/03, Peter Burden wrote:
>Paul DuBois wrote:
>
>>At 11:55 -0500 6/11/03, Christensen, Dave wrote:
>>
>>>I upgraded my test MySQL server yesterday to 4.1 and I
or
message.
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 1:30 PM
To: Christensen, Dave
Subject: Re: MySQL 4.1 and MyCC
MyCC does not support MySQL 4.1 coz the the library to
connect to MySQL 4.1 has changed.
Karam
--- "Ch
I upgraded my test MySQL server yesterday to 4.1 and I'm now receiving an
error when I try to connect using MyCC. The error is ERROR 1249: Client
does not support authentification protocol requested by server. Consider
upgrading MySQL client. I've tried to find a solution on the website, but
ei
:-) I think the first issue is to make sure that the server is running.
Typically the 'sock' file issue will solve itself if the server is running.
-Original Message-
From: Ernesto Silva [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 12:38 AM
To: [EMAIL PROTECTED]
Subject: Re: Ne
You should be able to find a file in your data directory titled
.err. What is the content of that file? If the server is having
problems running, you'll more than likely find information in that .err
file.
-Original Message-
From: Christensen, Dave [mailto:[EMAIL PROTECTED]
Is your server daemon running?
-Original Message-
From: Pratchaya Chatuphian [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2003 2:25 AM
To: [EMAIL PROTECTED]
Subject: ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
ERROR 2002: Can't conn
You can see more in-depth descriptions in the documentation, but for a
simple shot at migrating data and database structures from one machine to
another, you can try:
Prompt> mysqldump --add-drop-table <> -uroot
-ppassword | mysql --host=new.host.ip.add -uroot -ppassword
You can dink around wit
Not that particular move, but have used mysqldump/mysql combo to move
between linux-->windows and back. Works well.
-Original Message-
From: Greg Grasmehr [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 1:19 PM
To: [EMAIL PROTECTED]
Subject: Red Hat linux database to Mac OS X
He
If you check the documentation about mysqldump, you'll find the command line
syntax for using a combination of mysqldump on the source machine and mysql
pumping to the target machine. It's simple, fast and everything is there
to work just fine.
-Original Message-
From: Paul Najman [mailt
Since this in running in Windows, I don't think you will have much luck in
a simple console display. While you can change size properties for Window
and Screen Buffer, these sizes are ONLY for length and you can't really do
much for horizontal size.
What I'd suggest tying is to run mysql as a co
What is the source of the binary data you want to use to fill the blob?
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 12:23 PM
To: Adam Clauss; [EMAIL PROTECTED]
Subject: RE: How to fill an Blob with binary data
Like I said, for Image and te
Here's a link to an article that discusses how to set up cross-tab queries.
http://www.devshed.com/Server_Side/MySQL/MySQLWiz/page1.html
-Original Message-
From: Michael Shulman [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 12:08 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subj
:-) My offering would be to suggest developing in Delphi or Kylix,
depending on the platform.
David Christensen
Brokers International, Ltd.
1200 E Main St
Panora, IA 50216
(641) 755-2775
[EMAIL PROTECTED]
-Original Message-
From: Martin Gainty [mailto:[EMAIL PROTECTED]
Sent: Thursday
I've noticed something with MySQL Control Center. Today I wanted to browse
an entire table, which has roughly 35,000 rows. I unchecked the "limit to
1000" box in the General Options and double-clicked on the table. Once MyCC
started to display the table, my free memory dropped to 4 MB and perfor
March 23, 2003 5:36 AM
To: Christensen, Dave
Cc: 'mysql users'
Subject: RE: 4.0.12 RPM's
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 21 Mar 2003, Christensen, Dave wrote:
> I downloaded the RPM's from the Chicago mirror site and saved the
> files in a d
l displayed on my screen.
Thanks
Dave
David Christensen
Brokers International, Ltd.
1200 E Main St
PO Box 160
Panora, IA 50216
(800) 362-1097 or (641) 755-2775
[EMAIL PROTECTED]
-Original Message-
From: Lenz Grimmer [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 11:56 AM
To: Ch
Good Morning!
I'm trying to install the MySQL RPM's on a newly set up RH 8.0 box. Things
seem to go well until I try to install the "server" RPM, which fails stating
that it can't find libmysqlclient.so.10 on the computer. What do I have to
do to get around this problem?
Thanks!
David Christen
Since DBScripter uses ODBC, you'll have to set up a Data Source in the ODBC
manager in Windows for any database you wish to access with the product.
For that you'll need an Access driver, but you can download that driver from
MS at no cost. It would be nice if DBScripter would be ported to LINUX a
d T-G [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 12, 2003 9:45 PM
To: mysql users
Cc: j.urban; Christensen, Dave
Subject: Re: Licence Free Import/Export for Access?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dave & J, et al --
[re DBScripter and urSQL]
Those are nice tools, but if I
There's a relatively low-cost ODBC utility called DBScripter that does a
pretty good job creating scripts for exporting ddl and data from ODBC
datasources. It allows you to build dialects for server-based SQL
variations. I don't think that there's a current MySQL dialect, but looks
pretty simple
The problem you are having is a result of the permissions that are set on
the data and log directories that are identified in my.cnf, and is
documented in the MySQL Reference Manual. If you change the ownership of
the data and log directories to mysql (both user and group), the error
should go awa
Then go to c:\winnt\system32\drivers\etc and make the changes in the hosts
file that you will find there.
-Original Message-
From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 1:25 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP] Re: PHP and MySQL bu
You can use the command line mysql with the "host" option, i.e.
--host=, to connect to another machine. Likewise, you could set
up a data source using ODBC to look at the database on the second host
machine through which you could generate queries against the tables on the
other host's database ta
I can see where it would be nice to be able to do that.
-Original Message-
From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 4:06 PM
To: Christensen, Dave; 'Chris Boget'; [EMAIL PROTECTED]; Paul DuBois
Subject: Re: Query mysql
I think you could also use:
WHERE YEAR(date) = 2003
AND MONTH(date) = 01
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 02, 2003 5:09 PM
To: [EMAIL PROTECTED]
Cc: Max Clark
Subject: Re: Select Date Help
On 2 Jan 2003, at 14:2
Again, this specific problem is mentioned in the reference guide. From that
and my experiences, we're looking at a permissions issue. Hannes needs to
look at the permissions on his data and logging directories to make sure
that they are set to the default mysql:mysql.
-Original Message
Rick,
What messages are you seeing in the .err file in your logging directory? I
typically run my servers with the KDE up and I use the service configuration
tool to restart services. Have you tried to fire up MySQLCC and connect to
your server?
Dave
-Original Message-
From: Richard
If you check the MySQL reference guide, you'll see that the Errorcode 13 is
indicating that you don't have your permissions set up correctly for your
data and log directories. Once you fix that, you should (hopefully) be
okay.
David Christensen
Brokers International, Ltd.
1200 E Main St
PO Box 16
51 matches
Mail list logo
