results copying into MySQL
Brought to you by:
espiridiao
Menu
▾
▴
#1 results copying into MySQL
Jorge
I successfully converted all 5 tables of my 16MB
capacity Access2000 DB into MySQL in a fifth screen.
However, I failed on copying of the content (results)
of the editor (fifth screen) into the clipboard and
to the MySQL. Instructions are vague.
Is the fifth screen an editor screen?
Is it possible at this stage?
If not when and how?
How would require step-by-step instruction on how
to use results from the fifth screen.
Stefan
Logged In: YES
user_id=481192
I think you are using v 1.1 but in v 1.2 you can save the
result to disk, if your problem was not sove contact me to
try to solvit,
Regards,
Jorge
Logged In: YES
user_id=516334
Jorge,
Thanks for reply.
I upgraded to 1.2.
I saved tables to a disk.
But now, how to use them in an updating or creating of
MySQL database? I tried to import them into MySQL by use
of a MySQLFront GUI but without success. I think that I
will require step-by-step instruction on how to do it.
Would you please help me?
Stefan
Logged In: YES
user_id=481192
Hi Stephen,
I think I had your problem when tested the MySQL output in a
GUI, in this case it was the very good
MyCC.
What is the problem?
when you execute a SQL script in a GUI, it only uses the
script until the first ';' that in SQL
means end of instructions, so if you had a script w/ more
than one line, like when transfering the data (rows)
to the MySQL engine; it gaves a error because there more
than one ';'.
How it is solved?
Use the command line.
In page 373 of MySQL manual (PDF version) you will have the
way you can do it, but I can make step-by-step instruction:
I had the table deaths with more than 4.000 records an 80
fields, Access2SQL, made a file call
deaths.scp.
1- assuming that you saved the deaths.scp file to the bin
dir of MySQL.
2- go to the DOS prompt,
Type: cd C:
cd mysql\bin
3- Now execute mysql, with a batch file.
Type: mysql -h localhost -u toto -p < deaths.scp
Enter password: ********
localhost is the name of my server and toto is my dog's name
and my user name in MySQL.
4-It's done!
I hope that you can do the conversion, if there is any
problem fell free to contact me, if you can send me
some snapshots of the errors that the GUI gaves it will be
very helpfull.
And to finish I can tell you that the updating, deleting of
records is on is way, so the next release will have that
features.
Kind regards.
Jorge Espiridio
Logged In: YES
user_id=516334
Hi Jorge,
Thanks again for your help.
When you refer to page 373 - you meant number on
manual or at the bottom of an Acrobat Reader? There are
discrepancy ca.20 pages. I study the manual to be able to
do small adjustments.
I think you meant cd\ - not cd C:
I followed your step-by-step instruction to the point that
I successfully converted 3 out of 5 tables.
The two tables were converted partially only and shoved
the following errors at the command line:
1. ERROR 1062 at line 132: Duplicate entry 5-127
for key 1. (131 is a last row converted out of a few
hundreds)
2. ERROR 1062 at line 128: Duplicate entry 127 for
key 1. (127 is a last row converted out of a few hundreds)
I cannot find error, there are no duplications in tables,
so what it means?
All the best and keep in touch, Stefan
Logged In: YES
user_id=516334
Hi Jorge,
I tried to solve the problem but without your help, it
seems impossible.
Please help, Stefan
Logged In: YES
user_id=481192
Didn't you received my mail?
Here it is:
Thanks again for your help.
When you refer to page 373 - you meant number on
manual or at the bottom of an Acrobat Reader? There are
discrepancy ca.20 pages. I study the manual to be able to
do small adjustments .
The Page from the manual: 9.6 Using mysql in Batch Mode
I think you meant cd\ - not cd C:
Yes, sorry about the error.
:-[
I followed your step-by-step instruction to the point that
I successfully converted 3 out of 5 tables.
The two tables were converted partially only and shoved
the following errors at the command line:
1. ERROR 1062 at line 132: Duplicate entry 5-127
for key 1. (131 is a last row converted out of a few
hundreds)
2. ERROR 1062 at line 128: Duplicate entry 127 for
key 1. (127 is a last row converted out of a few hundreds)
It's hard to know what is the problem!
I don't know the type of fields that you have, how many, the
primary key, indexes,
the MySQL version, are you using a GUI or in batch mode?
In my opinion and by the few information/experience I had,
you have a memo field with blank chars like CR, FF, TAB; if
not maybe a duplicated index.
Check the table structure, and the data.
Feel free to contact me. :-)
Regards
Jorge Espirido
If you can solve the problem, only if you send me the
estructure of the DB and the records thet give the problem.
Looking forward to heare from you.
Jorge
Logged In: YES
user_id=481192
Thanks again for your help.
When you refer to page 373 - you meant number on
manual or at the bottom of an Acrobat Reader? There are
discrepancy ca.20 pages. I study the manual to be able to
do small adjustments .
The Page from the manual: 9.6 Using mysql in Batch Mode
I think you meant cd\ - not cd C:
Yes, sorry about the error.
:-[
I followed your step-by-step instruction to the point that
I successfully converted 3 out of 5 tables.
The two tables were converted partially only and shoved
the following errors at the command line:
1. ERROR 1062 at line 132: Duplicate entry 5-127
for key 1. (131 is a last row converted out of a few
hundreds)
2. ERROR 1062 at line 128: Duplicate entry 127 for
key 1. (127 is a last row converted out of a few hundreds)
It's hard to know what is the problem!
I don't know the type of fields that you have, how many, the
primary key, indexes,
the MySQL version, are you using a GUI or in batch mode?
In my opinion and by the few information/experience I had,
you have a memo field with blank chars like CR, FF, TAB; if
not maybe a duplicated index.
Check the table structure, and the data.
Feel free to contact me. :-)
Regards
Jorge Espirido
If it didn't solve, send me your DB (structure and the
records that give the problem only).
Regards,
Jorge
Logged In: YES
user_id=516334
Hi Jorge,
I cannot find a problem. My DB looks OK.
I used a batch mode described by you in step-by-step
instruction . I am using MySQL v. 4.0.1-alpha-max-nt.
As you will see the tables, Industry and JunInd, which
converted OK, are nearly identical to failed tables
Location and JunLoc.
I installed MyCC GUI instead MySQL-Front. However, an
Import function on my computer is unavailable/grayed out.
(Perhaps it is incomplete development.)
Therefore, I am attaching my DB asking for assistance.
All the best and keep in touch, Stefan.
DBtest.ace
Logged In: YES
user_id=516334
Jorge,
I found an ERROR 1062 on
http://www.mysql.com/doc/C/R/CREATE_TABLE.html in Comments.
Unfortunately, it does not help me much. Look yourself.
Did you get my DB? Please, let me know.
Stefan
Logged In: YES
user_id=481192
Hi Stefan,
I didn't get your DB.
I saw the article and still think that you hava a duplicated
entry.
More help only after saw the DB.
Regards,
Jorge
Logged In: YES
user_id=516334
Jorge,
Thank you very much.
A week ago, I replied with an attachment to your address
espiridiao@users.sourcefourge.net but it was returned to
me as undeliverable for 3 days. Therefore, I replied
directly on SourceFORGE.net. When you scroll to the bottom
of your page in the Tracker Detailed View where Attached
Files are you will find my Dbtest.ace file, which you can
download by clicking on Download.
Best regards, Stefan