Save the excel file as a CSV text file, then use LOAD DATA INFILE
command to import. See the mysql manual for usage and example.
On May 8, 2008, at 4:49 AM, Lord Gustavo Miguel Angel wrote:
Hi!
How i do for transfer data from excel file to mysql?
Some example?
Thanks
--
MySQL General Ma
Hi,
I have a weird one going on here. I have done this many times before
with MySQL 4.1, but now that I am trying to accomplish same task with
a MySQL 5.0.x setup, mysql is just not succeeding in importing the
mysqldump file.
I am doing a full mysql dump from a mysql master running 5.0.51
You could build it from source. The only challenge is figuring out
the configuration command for the target platform. I have compiled
for Core 2 Duo and G4 shown below, but not G5. Search the web for the
configuration command. or perhaps someone here on the list might
have the configura
ny ideas what could be wrong here or is this possibly a bug?
Regards, Kieran
On Dec 20, 2006, at 3:08 PM, Kieran Kelleher wrote:
I have MySQL 4.1.22 source installation on a 1.66 Intel Core Duo
Mac Mini running OS X Server 10.4.8. It is a slave replicating to a
master over ssl. Replication wo
I left out URL to source compilation procedure and flags in original
message. Here it is:
http://homepage.mac.com/kelleherk/iblog/C711669388/E20061121141451/
index.html
ANy advice would be really appreciated.
Regards, Kieran
On Dec 20, 2006, at 3:08 PM, Kieran Kelleher wrote:
I have MySQL
I have MySQL 4.1.22 source installation on a 1.66 Intel Core Duo Mac
Mini running OS X Server 10.4.8. It is a slave replicating to a
master over ssl. Replication works fine, however I get this error
always if I execute the STOP SLAVE statement
([EMAIL PROTECTED]) (none)> stop slave;
ERROR 20
Just make a backup of the database to a file using mysqldump and then
drop the database. If you need to recreate it again in the future,
you can use the mysqldump backup file.
On Nov 21, 2006, at 9:28 PM, Alfred Mak wrote:
Can I shutdown one of the databases in MySQL but not the whole
mysq
Ah well, got it done on my own. This might help someone else trying
to do this:
http://homepage.mac.com/kelleherk/iblog/C711669388/E20061121141451/
index.html
On Nov 21, 2006, at 11:41 AM, Kieran Kelleher wrote:
We have been doing onsite replication for a few years and now we
want to
Make a select query in Access whose result mimics the table layout of
the target table in MySQL. Then export the query as tab-delimited text
and import into the MySQL table using LOAD DATA INFILE.
On Jul 28, 2005, at 12:32 PM, Bing Du wrote:
Hello,
I've been looking around for a while. Seem
One compromise between the large 5 digit zips and the 9-digit zip+4's
is carrier route. There are about 600,000 carrier routes in the USA
each denoted by the 5-digit zip and the carrier route, for example
34685-R036. 600,000 is certainly more manageable than 70,000,000
zip+4's. Does anyone know
Just remember, there is a big difference in 5-digit ZIPs which cover a
large area (can be many miles in width and height) and 9-digit ZIP+4's
which usually cover a city block. Zip+4 lat/lngs provide greater
accuracy for accurate radius analysis of say a list of mailing
addresses for a mailing c
There are about 70 million ZIP+4's in the USA. Buying a data file that
you can import into your own database typically costs around $10,000
from the small handful of companies that actually compile the data!
However, there are data broker companies such as Melissa Data
(http://www.melissadata.c
We never dump the data just shutdown the slave, copy the data
directory and restart the slave. This practice is trustworthy
probably only where the servers are running on the same platform, mysql
server version and operating system.
-Kieran
___
I have a master-slave replication setup. A scheduled backup script on
the slave runs automatically at regular intervals.
The script slave does this:
shutdown the mysql server on the slave
backup the mysql data directory to backup media
restart the mysql server on the slave.
Using a setup like t
Just feedback to the MySQL team...
Query Browser will not launch on OS X 10.3.7
Here is console log output...
dyld: /Applications/MySQL Query Browser.app/Contents/MacOS/MySQL Query
Browser can't open library: /usr/lib/libstdc++.6.dylib (No such file
or directory, errno = 2)
J
That worked. Thanks very much! Danke, Gracias, Grazie, Merci, Go raibh
maith agat!
On Jan 6, 2005, at 3:38 AM, Gleb Paharenko wrote:
Hello.
Try 'rehash' command.
Kieran Kelleher <[EMAIL PROTECTED]> wrote:
[-- text/plain, encoding 7bit, charset: US-ASCII, 15 lines --]
Normall
Normally, when you type the first few letters of a table name and press
tab, the mysql client does not auto complete anymore. Can this be
enabled with a my.cnf setting or something since it is no longer the
default behaviour on my machine?
Regards, Kieran
__
I guess you would would have to write some custom code that has
connections to each database server and operates outside of MySQL to do
this.
For example, WebObjects (www.webobjects.com) allows you to have
multiple EOModels (Enterprise Object models) in a project, each EOModel
can represent a
This is my favorite advanced MySQL book. It's by Jeremy Zawodny (looks
after MySQL installations for Yahoo.com) (fix the link if it wordwraps
in this email):
http://www.amazon.com:80/exec/obidos/ASIN/0596003064/kieranwebobje-20?
creative=327641&camp=14573&link_code=as1
-Kieran
___
I am trying to figure out the best innodb paramaters in the my.cnf
file. Server is XServe, single CPU, G4 1 GHz, OS X Panther 10.3.4 with
2 GB RAM and 180GB hard drive, MySQL version 4.0.20. Right now I am
running on default params.
Does anyone out there have a suggested innodb parameters or e
Mac OS X is well supported by MySQL. MySQL is even preinstalled in Mac
OS X Server, although we choose to ignore the OS X Server installation
in favor of installing the binary so that development and servers all
have the MySQL files in the same paths. Developers in our company run
MySQL on our
ster_user=Replikator
master_password=hackmack23
master_port=3306
server_id=10
[WinMySQLAdmin]
Server=D:/databank/bin/mysqld-nt.exe
note : user/pw correct :(
-Pierre Rousseau
-x->-Ursprüngliche Nachricht-----
-x->Von: Kieran Kelleher [mailto:[EMAIL PROTECTED]
-x->Gesendet: Donnerstag, 24. Juni
Log into the slave and do this command
mysql> mysql> show slave status\G
. what do you see?
Also, what is in your my.cnf file on the slave?
FYI, here is instructions on how I set up replication last week
http://homepage.mac.com/kelleherk/iblog/C711669388/E351220100/index.html
-Kieran
__
..
but it isnt "The simplest thing to do" as you say
:P
i am studying this:
http://dev.mysql.com/doc/mysql/en/Replication_HOWTO.html
thx another time
d2clon
On Thursday 24 June 2004 15:22, Kieran Kelleher wrote:
The simplest thing to do is set up a replication slave and run a
script
every
The simplest thing to do is set up a replication slave and run a script
every night that shuts down the MySQL slave, performs the backup, and
then restarts MySQL. We have a dedicated XServe running MySQL and we
use another XServe whose primary function is filesharing to also act as
a replicatio
Get the recently published book from Jeremy Zawodny. It's excellent.
Very easy to understand and goes through all the admin stuff. It has a
chapter dedicated to replication and explains in simple concise steps
how to set up replication. It demonstrates many different types of
replication config
se this particular one for access??
_______
Kieran Kelleher
Director of Product Development
SmartleadsUSA,LLC
2656 West Lake Rd
Palm Harbor, FL 34684
[EMAIL PROTECTED]
727-785-0766 x33
.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
_______
Kieran Kelleher
Palm Harbor, Florida USA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
WebObjects (30 day demo or $699) has a tool called Enterprise Object Modeler
which reads in a database schema directly from the database and generates
all the database diagrams, etc. and can generate Enterprise Objects in java
to interact with the database. Might be worth playing with the demo to g
On Mac OS X (also FreeBSD Unix), a new installation installs the new version
in another folder and changes the /usr/local/mysql symbolic link to point to
the new installation (in the same folder) but the old installation is intact
there aswell. So navigate to /usr/local and see what you have there.
FYI
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Anjo Krank
Sent: Monday, June 02, 2003 1:41 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: WWDC 2002 Tracks
Hi everybody,
I haven't seen a message yet, so: Apple has made the video tracks from
last
Define the field as type ENUM [NOT NULL] with values "N" and "Y", but read
and understand the ENUM type before you use it so you understand what
happens when someone tries to insert something other than Y or N. ENUM (Y/N)
is what MySQL uses in the mysql permissions database. So, examine some of
the
What platform and hardware spec are you using?
-Original Message-
From: Per Andreas Buer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2003 1:48 PM
To: [EMAIL PROTECTED]
Subject: mysql/innodb and the 2GB limit
Hi.
Lately, I've been banging against the glibc 2GB malloc limit - what a
Use 'char' instead of 'varchar' and INDEX the fields that you will be using
in the WHERE clause of your SELECTS.
-Original Message-
From: Ulterior [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 31, 2003 10:35 AM
To: [EMAIL PROTECTED]
Subject: Re: Insert query
sow what would you suggest, J
Getting EO Modeler in WO 5.2.1 to connect to MySQL 4.0.12 on Windows 2000 is
evading us somehow and giving us a dreaded connection error. It works fine
on OS X I know it is something to do with Classpaths and the fact that
EO Modeler uses a different JDBC connector than WO.
1) If someone out
Ted,
4.1 is not in production release yet. So, for home development to test or
develop for new features specific to 4.1, then OK. If your database server
is for production use serving critical data, then use 4.0.13 which is the
current production release. Follow the instructions carefully a
36 matches
Mail list logo