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
In the data directory for MySQL, you should find a file titled
hostname.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
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 databasename
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
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
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
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'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
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]'
Subject: RE: Unable
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
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
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
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)
To: 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 are created
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 Blanchard'; [EMAIL
]
mailto:[EMAIL PROTECTED] ]
Sent: Thursday, June 19, 2003 10:10 AM
To: Dickey, Dallas; Christensen, Dave; [EMAIL PROTECTED]
Subject: RE: Odd thing
[snip]
mysqldump AgentAdminDB activitylookup -u UserName -pPassword
//var/data/mysql/activitylookup.sql
mysqldump AgentAdminDB agencies -u UserName
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]
Sent: Thursday
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]'
Subject: RE: Odd thing
Importance: High
-
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
script file.
-Original Message-
From
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
.
-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
--- Christensen, Dave
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'm now receiving an
error when I try to connect using
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
receiving an
error when I try to connect using MyCC. The error is ERROR
:-) 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:
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
You should be able to find a file in your data directory titled
hostname.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
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 lots of variety here -uroot
-ppassword | mysql --host=new.host.ip.add -uroot -ppassword
You
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
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
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
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
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]
:-) 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:
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
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 directory /data/downloads/mysql. I
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
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: Christensen, Dave
Cc: 'mysql users'
Subject: Re: 4.0.12
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
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
[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 read you
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
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 on another
You can use the command line mysql with the host option, i.e.
--host=hostname, 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
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
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
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
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
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
51 matches
Mail list logo
