Am 05.10.2014 um 22:39 schrieb Jan Steinman:
I've had good experiences moving MyISAM files that way, but bad experience
moving INNODB files. I suspect the latter are more aggressively cached
simply no, no and no again
independent of "innodb_file_per_table = 1" there is *always* a global
tabl
* Reindl Harald [141005 13:12]:
>
> Am 05.10.2014 um 21:29 schrieb Tim Johnson:
> >I have a dual-boot OS X/Ubuntu 12.04 arrangement on a mac mini. The
> >ubuntu system has failed and I am unable to boot it.
> >
> >I have one database on the ubuntu partition that was not backed up.
> >
> >I am abl
* Jan Steinman [141005 13:12]:
> > So, this is a "Help me before I hurt myself" sort of question: Are
> > there any caveats and gotchas to consider?
> Do you know if the database was shut down properly? Or did Ubunto
> crash and die and your partition become unbootable while the
> database was i
Am 05.10.2014 um 21:29 schrieb Tim Johnson:
I have a dual-boot OS X/Ubuntu 12.04 arrangement on a mac mini. The
ubuntu system has failed and I am unable to boot it.
I have one database on the ubuntu partition that was not backed up.
I am able to mount the ubuntu partion with fuse-ext2 from Mac
> So, this is a "Help me before I hurt myself" sort of question: Are
> there any caveats and gotchas to consider?
Do you know if the database was shut down properly? Or did Ubunto crash and die
and your partition become unbootable while the database was in active use?
Either way, you need to mak
2013/3/31 Norah Jones
> Hi,
>
> To source sqldump i can use the source command, but if I need to do the
> same stuff using command line without going to the sqlpromt, can I achieve
> that.
>
>
Hello,
You mean cat sqldump.sql | mysql -uwhatever -pwhatever whatever_database ?
Manuel.
On 29 Oct 2011, at 22:59, luci spam wrote:
> I have 2 servers (1 for development, 1 for service)
>
> I keep ADD/DELETE columns and CREATE/DELETE Indexes on my development
> server, so these 2 server have similar but different mysql data structures.
>
> I know there's an option to expert structur
: Paul DuBois
To: Nunzio Daveri
Cc: mysql@lists.mysql.com
Sent: Tue, August 3, 2010 12:09:05 AM
Subject: Re: Importing User credentials from mysql.sql file???
On Aug 2, 2010, at 3:57 PM, Nunzio Daveri wrote:
> Hello Gurus, I just upgraded several MySQL 4.1 to 5.1 versions and also
>
On Aug 2, 2010, at 3:57 PM, Nunzio Daveri wrote:
> Hello Gurus, I just upgraded several MySQL 4.1 to 5.1 versions and also
> wanted
> to know how to extract the user name, password and credentials from the
> mysql.sql file (around 22 of them per server - have 8 servers total)? The
> contract
Gary Smith wrote:
Patrice Olivier-Wilson wrote:
Gave it a try got this:
MySQL said:
#1062 - Duplicate entry '1' for key 1
Yeah, that's what I was saying about in my previous mail. It looks
like you've got a primary key on one of your columns, and you're
attempting to insert data into it with
Patrice Olivier-Wilson wrote:
Gave it a try got this:
MySQL said:
#1062 - Duplicate entry '1' for key 1
Yeah, that's what I was saying about in my previous mail. It looks like
you've got a primary key on one of your columns, and you're attempting
to insert data into it with a duplicate primary
Gary Smith wrote:
Patrice Olivier-Wilson wrote:
I have data I need to keep in both db just trying to merge.
There's two ways around this:
First is to not export the structure (uncheck structure). The second
is to export with "if not exists". This should (IIRC) do a create
table if not ex
Patrice Olivier-Wilson wrote:
I have data I need to keep in both db just trying to merge.
There's two ways around this:
First is to not export the structure (uncheck structure). The second is
to export with "if not exists". This should (IIRC) do a create table if
not exists, so it'll do w
Gary Smith wrote:
Patrice Olivier-Wilson wrote:
I have 2 databases, different domains. Both have a table named
'tips'... both have different contents in the table.
Using phpMyAdmin for GUI.
I want to export databaseA tips as sql (done) then import content
into databaseB tips. But when I run t
Patrice Olivier-Wilson wrote:
I have 2 databases, different domains. Both have a table named
'tips'... both have different contents in the table.
Using phpMyAdmin for GUI.
I want to export databaseA tips as sql (done) then import content into
databaseB tips. But when I run that operation, the
On 17/12/2009 17:46, mos wrote:
"Load Data ..." is still going to be much faster.
Mike
Hiya
If you using on Linux and using LVM, look at mylvmbackup.
HTH
Brent Clark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mys
At 03:59 AM 12/17/2009, you wrote:
Madison Kelly wrote:
Hi all,
I've got a fairly large set of databases I'm backing up each Friday. The
dump takes about 12.5h to finish, generating a ~172 GB file. When I try
to load it though, *after* manually dumping the old databases, it takes
1.5~2 days
Madison Kelly wrote:
Hi all,
I've got a fairly large set of databases I'm backing up each Friday.
The dump takes about 12.5h to finish, generating a ~172 GB file. When
I try to load it though, *after* manually dumping the old databases,
it takes 1.5~2 days to load the same databases. I am gue
Madison Kelly wrote:
Hi all,
I've got a fairly large set of databases I'm backing up each Friday. The
dump takes about 12.5h to finish, generating a ~172 GB file. When I try
to load it though, *after* manually dumping the old databases, it takes
1.5~2 days to load the same databases. I am gue
n Towey
Cc: mysql@lists.mysql.com
Subject: Re: Importing large databases faster
Gavin Towey wrote:
> There are scripts out there such at the Maatkit mk-parallel-dump/restore that
> can speed up this process by running in parallel.
>
> However if you're doing this every week on that l
Gavin Towey wrote:
There are scripts out there such at the Maatkit mk-parallel-dump/restore that
can speed up this process by running in parallel.
However if you're doing this every week on that large of a dataset, I'd just
use filesystem snapshots. You're backup/restore would then only take
There are scripts out there such at the Maatkit mk-parallel-dump/restore that
can speed up this process by running in parallel.
However if you're doing this every week on that large of a dataset, I'd just
use filesystem snapshots. You're backup/restore would then only take as long
as it takes
Hi Tim,
Try using LOAD DATA INFILE from the mysql CLI. PMA can often introduce
unexpected behavior for export/import.
Regards,
Gavin Towey
-Original Message-
From: Tim Thorburn [mailto:webmas...@athydro.com]
Sent: Wednesday, September 16, 2009 7:14 AM
To: mysql@lists.mysql.com
Subject:
Ali, Saqib wrote:
I exported a large data set from from Microsoft SQL server in CSV
format. However whenever I try to import that data to a a mySQL server
running on Linux, it adds a space between each character in each
field.
Essentially:
Saqib Ali
becomes
S a q i b A l i
I have tried to use
> try "OPTIONALLY ENCLOSED BY ' " '
already tried that. no help :(
saqib
http://doctrina.wordpress.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
It sounds like you want to easily create a new MySQL table that is a
copy of a table in a different DBMS.
The way I would do it is generate a DDL script from the other DBMS
(create table etc.) For example, SQL Server has a "generate script"
wizard that does it for you automatically. Then take th
Dave M G schrieb:
PHP List, MySQL List
In my PHP environment, I have "Magic Quotes" turned off, and I use the
mysql_real_escape_string() function clean strings of SQL syntax before
inserting them into my database.
So the data stored in my database does not have escape characters in it.
Part
, it
will add them because it's constructing sql statements, and they have
to be escaped.
I would take phpMyAdmin out of the equation and just use mysqldump. You
should have no problem doing something like creating a scratch table,
dumping it, and re-importing from the dump.
mysql>
A little bit easier of a way to do this could be the following command:
mysql -u[user] -h[host] -p [database] < [mysql dump file]
Make sure the database you're importing into is EMPTY (or at least the
TABLES you are importing to are empty...)
On 10/19/07, Werner Van Belle <[EMAIL PROTECTED]> wro
Hello,
If it is a dump you can pipe it into mysql. If you have a csv like file you
can import it with LOAD DATA LOCAL INFILE like things. An example below:
DROP TABLE IF EXISTS EnsgDescriptions;
CREATE TABLE IF NOT EXISTS EnsgDescriptions
(stable_id VARCHAR(128) PRIMARY KEY,
description VARCHAR
Hi, sam
You can try to export table to file from Excel in CSV format.
And then import data from this file to mysql.
Something like this should help you:
LOAD DATA INFILE 'yourtabledata.txt' INTO TABLE yourtable FIELDS
TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
sam rumaizan
Hi,
LOAD DATA restricts only on BLOB,TEXT,ENUM and FIXED DATA. Others are
equally supported [INSERT stmt]. Likewise for mysqlimport also.
If the data file has no delimiter other than space[even the name,
addresss,etc contain spaces], then the target table will not the one what is
expected,
In the last episode (Nov 17), John Kopanas said:
> On 11/17/06, Dan Nelson <[EMAIL PROTECTED]> wrote:
> >In the last episode (Nov 17), John Kopanas said:
> >> I have a text file with over 500K rows of data in it. The problem
> >> is that the data is no seperated by commas but instead occupy a
> >>
I am trying to figure out how this would work? How does LOAD DATA
figure out when one column begins and another ends when some of the
data are addresses with spaces in them?
On 11/17/06, Dan Nelson <[EMAIL PROTECTED]> wrote:
In the last episode (Nov 17), John Kopanas said:
> I have a text file
In the last episode (Nov 17), John Kopanas said:
> I have a text file with over 500K rows of data in it. The problem is
> that the data is no seperated by commas but instead occupy a certain
> amount of characters. So for instance:
>
> ID 1 -11
> NAME 12-50
> COMPANY_NAME 51-100
> ...
>
> How
I did a little shell script to do it. the key was the shell variable IFS:
Normally IFS=" "
to make it work right I set it as follows:
IFS="
"
Yes, thats a newline between the quotes
John Kopanas wrote:
I have a text file with over 500K rows of data in it. The problem is
that the data is
David Blomstrom wrote:
Hopeffully this will be the last question in this series. :)
I want to copy a database from my PC to my Apple laptop. I installed MySQL's
GUI Tools on both computers, created a file named Backup.mpb on my PC, then put
a copy of it on my Mac. Now I'm trying to figure out
On 6/22/06, Scott Haneda <[EMAIL PROTECTED]> wrote:
I have two chunks of data to import, one is in this format:
"01001 - AGAWAM, MA","01001",0,0,291,249,0,"42.070206","-72.622739"
Where it is comma sep and partially quoted
The other is in this format
"99502 ANCHORAGE,
AK","256","265","1424","196
Hi,
No unfortunately not...
Cheers
Ian
> -Original Message-
> From: John Meyer [mailto:[EMAIL PROTECTED]
> Sent: 25 June 2006 05:41 PM
> To: mysql@lists.mysql.com
> Subject: Re: Re-importing a mysqldump file
>
> Ian Barnes wrote:
> > Is this possible? Or woul
Ian Barnes wrote:
Is this possible? Or would the best way be to import the dumped file into a
temp table and then select out of the temp table into my correct table ?
Anyway to use a trigger?
--
Online library -- http://pueblonative.110mb.com
126 books and counting.
--
MySQL General Mailing
Hi,
I need to auto re-import a mysqldump file, but when importing it I need to
make a certain field a value for all information imported. For example my
db looks like this:
Id
Name
Value
Serverid
Now, on the remote server, name and value get exported, and when I re-import
it here, I
Scott Haneda wrote:
I have two chunks of data to import, one is in this format:
"01001 - AGAWAM, MA","01001",0,0,291,249,0,"42.070206","-72.622739"
Where it is comma sep and partially quoted
The other is in this format
"99502 ANCHORAGE,
AK","256","265","1424","1962","1131","528","643","6209","9
09 June 2006 07:15 PM
> To: mysql@lists.mysql.com
> Subject: Re: Importing 3Gb File
>
> At 10:20 AM 6/8/2006, you wrote:
> >Hi,
> >
> >I am trying to import a 3.2Gb sql dump file back into my sql server
> (4.1.12)
> >and im coming across the following error:
>
Sent: 09 June 2006 05:01 PM
> To: Ian Barnes
> Cc: mysql@lists.mysql.com
> Subject: Re: Importing 3Gb File
>
> Hi Ian,
>
> > I am trying to import a 3.2Gb sql dump file back into my sql server
> (4.1.12)
> > and im coming across the following error:
> >
&
: mysql@lists.mysql.com
> Subject: Re: Importing 3Gb File
>
> At 10:20 AM 6/8/2006, you wrote:
> >Hi,
> >
> >I am trying to import a 3.2Gb sql dump file back into my sql server
> (4.1.12)
> >and im coming across the following error:
> >
> >mysql: Out of me
> At 10:20 AM 6/8/2006, you wrote:
> >Hi,
> >
> >I am trying to import a 3.2Gb sql dump file back into my sql server
> (4.1.12)
> >and im coming across the following error:
> >
> >mysql: Out of memory (Needed 178723240 bytes)
> >mysql: Out of memory (Needed 178719144 bytes)
> >
> >That error come
At 10:20 AM 6/8/2006, you wrote:
Hi,
I am trying to import a 3.2Gb sql dump file back into my sql server (4.1.12)
and im coming across the following error:
mysql: Out of memory (Needed 178723240 bytes)
mysql: Out of memory (Needed 178719144 bytes)
That error comes up after about 30 minutes wor
Hi Ian,
I am trying to import a 3.2Gb sql dump file back into my sql server (4.1.12)
and im coming across the following error:
mysql: Out of memory (Needed 178723240 bytes)
mysql: Out of memory (Needed 178719144 bytes)
That error message comes from some single place trying to allocate 178MB
On 6/8/06, Ian Barnes <[EMAIL PROTECTED]> wrote:
Hi,
I am trying to import a 3.2Gb sql dump file back into my sql server (
4.1.12)
and im coming across the following error:
mysql: Out of memory (Needed 178723240 bytes)
mysql: Out of memory (Needed 178719144 bytes)
That error comes up after ab
one I have wondered about myself.
Is there a way in mysql to "attach" to session to issue a commit?
-Original Message-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 3:02 PM
To: Luke Vanderfluit
Cc: MySQL List
Subject: Re: importing a dumpfile f
to session to issue a commit?
-Original Message-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 3:02 PM
To: Luke Vanderfluit
Cc: MySQL List
Subject: Re: importing a dumpfile from with the mysql client
On 5/4/06, Luke Vanderfluit <[EMAIL PROTECTED]> wrote:
:) )
This is a good question, one I have wondered about myself.
Is there a way in mysql to "attach" to session to issue a commit?
-Original Message-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 3:02 PM
To: Luke Vanderfluit
Cc: MySQL List
Subject: Re
On 5/4/06, Luke Vanderfluit <[EMAIL PROTECTED]> wrote:
[snip]
I started this process remotely then went to the site to finish it.
But when the dump finished (several hours later) I was not able to
execute the following commands from my original location.
mysql> SET FOREIGN_KEY_CHECKS = 1;
mysq
Hi everyone.
I used to run mysql on a local server here, which has some databases
which are very important to me on it. The server was running mysql
on Arch Linux, but unfortunatly this crashed, I was not able to
rebuild the operating system but I was able to recover the raw
database files of
Hi Chris,
Looks like you may have to either upgrade your current server to the
version the Arch Linux was running or install a second temp server of
that version, export the databases and then import them into the ver 3.2
server.
Personally, I'd look closely at upgrading if at all possible.
Rega
Hi Derek,
You never gave us a "SHOW CREATE TABLE simple1", which would have
helped. To replicate your problem, I did the following, on a linux
box (it looks like you're using Windows), using mysql
5.0.18-standard-log:
CREATE DATABASE cars;
use cars;
CREATE TABLE `simple1` (
`one` char(10) de
[EMAIL PROTECTED] wrote:
(response interspersed)
Boris Villazon <[EMAIL PROTECTED]> wrote on 10/14/2005
08:30:13 AM:
Hi
I am working with MySql 4.1.14 under Windows XP.
I am trying to do a database import from a file.
I have the following table definiton
CREATE TABLE attribute_instan
(response interspersed)
Boris Villazon <[EMAIL PROTECTED]> wrote on 10/14/2005
08:30:13 AM:
> Hi
>
> I am working with MySql 4.1.14 under Windows XP.
>
> I am trying to do a database import from a file.
>
> I have the following table definiton
>
> CREATE TABLE attribute_instance (
> name v
Francesco R. wrote:
Alle 08:21, giovedì 13 ottobre 2005, Huub ha scritto:
Hi,
Can someone tell me if it is anyhow possible to import a dBaseIII+
database into MySQL and if so: how?
On linux there is "dbf2mysql"
http://packages.debian.org/stable/misc/dbf2mysql
On windows you could import t
Alle 08:21, giovedì 13 ottobre 2005, Huub ha scritto:
> Hi,
>
> Can someone tell me if it is anyhow possible to import a dBaseIII+
> database into MySQL and if so: how?
>
On linux there is "dbf2mysql"
http://packages.debian.org/stable/misc/dbf2mysql
On windows you could import the tables in m$acc
Original Message
From: "Oddvar Kragseth" <[EMAIL PROTECTED]>
To: ; <[EMAIL PROTECTED]>
Sent: Sunday, February 13, 2005 3:35 PM
Subject: Importing a separated file into mysql, national charset
problem??
> I'm importing a file into mysql.
>
> Most work fien, but numbers are given like this
Hi,
Sweet! Thank you Jeremy!
FYI, make sure you grab the libmygis-0.3.tar.gz or later instead of any
other version. I had some silly mistakes that made the DBF file
required instead of optional. I've also ported to Mac OS X in 0.3.
Regards,
Jeremy
--
Jeremy Cole
Technical Yahoo - MySQL (Datab
Sweet! Thank you Jeremy!
-James
On Feb 12, 2005, at 3:52 PM, Jeremy Cole wrote:
Hi David,
I want to import some data into my database, but it's
in an ArcView Shapefile, which I've never worked with.
Does anyone know what kind of software I can use to
access this data? Actually, I'd probably import
Hi David,
This sounds really cool. One question, though...when
you talk about downloading the "source code," are you
saying your program is for Linux only? As much as I
hate Microsoft, I'm still stuck with Windows XP.
I developed it on Linux, and haven't ever tried to compile it on
Windows, as I d
Aha - that's why I like to ask questions on newsgroups
rather than get secondhand news from Google! :)
This sounds really cool. One question, though...when
you talk about downloading the "source code," are you
saying your program is for Linux only? As much as I
hate Microsoft, I'm still stuck with
Hi David,
I want to import some data into my database, but it's
in an ArcView Shapefile, which I've never worked with.
Does anyone know what kind of software I can use to
access this data? Actually, I'd probably import it
into a spreadsheeet first, then save it as a csv file
and import it into my d
David -
Here is a link to search results on http://www.esri.com.
http://search.esri.com/results.cfm?
h=10&ho=0&q=arcview+shapefile&sa.x=26&sa.y=11
ESRI is the leader in GIS software and the maker of the application,
"ArcView". Check out the link for the first search result on the link
I gave
> -Original Message-
> From: David Blomstrom
> Sent: Thursday, February 10, 2005 10:06
> To: mysql@lists.mysql.com
> Subject: Importing Tables on Top of Tables
>
> If I revise a MySQL table and try to publish it
> online, I often get the error message, "Table my_table
> already exists."
I found SQLyog Enterprise (www.webyog.com) to be the
best when importing data from ODBC to MySQL.
Karam
--- Peter Brawley <[EMAIL PROTECTED]> wrote:
> Using a data modelling tool (like Dezign from
> Datanamic) or a scripting
> tool (like DbScripter), all you need do, I think, is
> load the Acces
Using a data modelling tool (like Dezign from Datanamic) or a scripting
tool (like DbScripter), all you need do, I think, is load the Access
database into the tool, configure the tool to create an export script
for MySQL (say, using InnoDB to enable FKs), touch up as desired, and
generate the s
Its my understanding you need InnoDB table types, but I do not know of the
single foreign key per table. I have a DB with multiple foreign keys per table
and its seems to work fine.
Bob
-Original Message-
From: Paun [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 11, 2005 5:19 PM
To:
One reason may be due to your ON condition.
ON table2.ID=table2.ID_table1
You reference table 2 twice and I doubt that on the table2 table id equals
id_table1 very often. Because table2 is LEFT JOINed to table1, you will
only be able to update the rows that match your ON condition. Again, that
OK, now I really feel stupid. It helps to change the ownership of the
files to mysql:mysqlduh.
Curtis
Curtis Maurand wrote:
I didn't, but I'll give it a shot and see what happens.
Curtis
Michael J. Pawlowsky wrote:
Curtis Maurand wrote:
If I create one of the databases and then put the files
I didn't, but I'll give it a shot and see what happens.
Curtis
Michael J. Pawlowsky wrote:
Curtis Maurand wrote:
If I create one of the databases and then put the files for that
database from the old installation in place of the newly created
ones, the database is recognized, but i get errors say
Hi,
An SQL-statement that is conceptually equal to the following caused some
astonishment.
UPDATE table1
LEFT JOIN table2 ON table2.ID=table2.ID_table1
SET table2.value=table2.value-IF(table1.condition=7,1,0),
table1.condition=8
WHERE table1.ID=$id
My problem is the IF condition, which alway e
Curtis Maurand wrote:
If I create one of the databases and then put the files for that
database from the old installation in place of the newly created ones,
the database is recognized, but i get errors saying that the columns in
the tables are not recognized.
I'd really like to get this data ba
If you have direct MySQL tool access to your existing data you could
re-export your data using the mysqldump tool and set the
"--max_allowed_packet" option to the same value as the max_allowed_packet
size for your new server. That way, if you "source" the resulting dump
file into your new serve
On Thursday 02 of December 2004 01:15, Michel RENON wrote:
> Hi,
>
> Here is my problem :
> I want to copy datas from an existing website to my local website.
> The website is a collection of images with thumbnails.
> With phpMyAdmin, i made an export of the image table and i have a 16 MB
> file 'i
I've used the 'load data infile' command to import data from a file and it
worked well for my purposes. See
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html for the full syntax.
Rhino
- Original Message -
From: "Manuel J. Contreras Maya" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
I managed to do it using
mysql> load data infile '/home/manuel/databases/import.txt'
-> into table countries
-> fields terminated by ';';
Query OK, 240 rows affected (0.01 sec)
Records: 240 Deleted: 0 Skipped: 0 Warnings: 18
(I will check the warnings...)
I guess my system do not have mysq
There's a tool called "mysqlimport". I recommend using that. Or, if you
have to extract data from a larger set, you could write a program. But,
mysqlimport is the easiest way. If you're on a UNIX machine, run 'man
mysqlimport' for more information.
Good luck,
Brian
-Original Message-
Fr
Thanks to all for your suggestions
just have to try all now
Thanks!
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
See http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
Hope that helps.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / //
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| We have clients sending us xls file.
| We export them as csv files, using commas or semi-colons. as delimiters and
| then make an import in mysql.
| Problem : some of the fields, containing texts, have sometimes already a
| comma or a semi-colon in th
bertrand
i went to tab delimited fields for the same reason:
commas in text is often done, tabs is rarely done.
david
> -Original Message-
> From: Bertrand Gac [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 21, 2004 12:09 AM
> To: mysql
> Subject: Importing Excel Data in MySql
>
>
> You could do a find & replace and change every ; to some other symbol
> directly in excel before importing
I'm not sure our clients will appreciate if I modify their ponctuation
everuwhere :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
I use a tool called navicat. In supports excel imports excellent. They have
a shareware version on their page you can try out.
www.navicat.com
Regards
/Jonas
-Original Message-
From: Bertrand Gac [mailto:[EMAIL PROTECTED]
Sent: den 21 oktober 2004 09:09
To: mysql
Subject: Importing Excel
In article <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]> writes:
> Thanks, it is working for the mentioned format.
> Is there any method for importing directly the spooled file from oracle without
> changing the file format into the required format like using tab and newline.
I don't know Oracle,
[mailto:[EMAIL PROTECTED]
Sent: Thu 9/30/2004 2:01 AM
To: Lakshmi NarasimhaRao (WT01 - TELECOM SOLUTIONS)
Cc: [EMAIL PROTECTED]
Subject: Re: importing data into mysql from oracle using a text file
Hi,
I did imported your data im
Hi,
I did imported your data im my server but I had to do some changes to sample.txt.
I have replaced in a text editor "\t" with empty string. is a real tab
while \t is just a text. Additional change was to replace "\n" (which is text but not
newline with empty string). The I did the following (b
Title: Re: importing data into mysql from oracle using a text file
The sample lines are like this in
alarm.txt
ARRIVED DETECTED
NAME
TYPE ALARMLEVEL V DISCLOSED CATEGORY_NUM
EVENTID
Can you post one or 2 sample lines from alarm.txt ?
Regards,
Andrey
P.S.
(i am not on [EMAIL PROTECTED] so add me to the CC:)
[EMAIL PROTECTED] wrote:
Hi,
I tried with the spool option to get the data from the tables in the oracle.
For this go to pl/sql editor, go to file menu, select
My tounge spoke too early, sorry!
Sebastian Haag said:
> Hello,
>
> is it possible to import data into a MySQL-DB from a text-file which does
> not have separating characters (like a comma, semicolon or tab)?
>
> I have a .csv-file in which each column has a different constant lenght
> (so many ch
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
On Wednesday 11 August 2004 10:27, Cemal Dalar wrote:
> make you text file format same as the table format . then use
>
> mysqlimport database_name table_name.txt
>
> by default mysqlimport need tab delimited text. if you need ; or other
> use --f
It sounds like you want the LOAD DATA function, found at
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
As long as there is some wat of distinguishing the two fields in the
file, you can load them into MySQL.
Mike Hillyer
Robin Lynn Frank wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD
make you text file format same as the table format . then use
mysqlimport database_name table_name.txt
by default mysqlimport need tab delimited text. if you need ; or other
use --fields-terminated-by=
http://dev.mysql.com/doc/mysql/en/mysqlimport.html
Best Regards,
Cemal Dalar a.k.a Jimmy
Sys
Taylor [mailto:[EMAIL PROTECTED]
Sent: 23 July 2004 17:53
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: IMPORTING
On Friday 23 July 2004 03:02 pm, you wrote:
> sqlog program
What is "sqlog program"? Google shows me nothing familiar:
http://www.google.com/search?q=sqlog
On Friday 23 July 2004 03:02 pm, you wrote:
> sqlog program
What is "sqlog program"? Google shows me nothing familiar:
http://www.google.com/search?q=sqlog+program
You need to provide more information if you want help. How do you run this?
What OS? What options are you selecting? How do you con
You don't say what version you are running.
Did you forget to commit?
[EMAIL PROTECTED] wrote:
Dear friends,
When I import records fron csv file.I window pops up, stating total number of
records imported, however when I check table nothing has been imported.Any
guidance,
--
MySQL General Mai
On Friday 23 July 2004 11:14 am, [EMAIL PROTECTED] wrote:
> Dear friends,
> When I import records fron csv file.I window pops up, stating total number
> of records imported, however when I check table nothing has been
> imported.
You are using some kind of middle-man program to populate a databas
1 - 100 of 184 matches
Mail list logo