Solved

Dbf 2 MySql table

Posted on 2002-07-15
15
655 Views
Last Modified: 2010-04-04
I need to move fields from a dbf table to MySql for use on my server.

Any suggestions ?

Please codes or freeware components .
0
Comment
Question by:ginsonic
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 3
  • 2
  • +2
15 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7155264
a tbatchmove-component,
two aliases pointed to the different databases

is needed, and a bit code,
thats all


meikl ;-)
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7155374
Can you help me with a sample project ?
0
 
LVL 3

Expert Comment

by:marcoszorrilla
ID: 7155563
Perhaps a bit of SQL:

Select MyTableDbf.* INTO MyNewTable
FROM MyTableDbf;

Best Regards.
Marcos.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Author Comment

by:ginsonic
ID: 7156182
I don't wish to make a sql copy of my dbf table.
I just wish to copy one field into another MySqol field and all others left fields from dbf into a single MySql field.

Dbf          MySql
Field1       Field1
Field2+' '+
Field3+' '+
Field4       Field2  
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7156186
Dbf                            MySql
Field1                        Field1
Field2+' '+
Field3+' '+
Field4                        Field2  
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7156222
I found next link for this conversion:
http://ae.inc.ru/dbf2mysql_src.php3

But I need just couple line to copy a field into MySql first field and others fields into the second MySql field.

300 points for this.
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7156327
with local-sql

for create

create ::mySQL_Alias::tablename
as
select fieldname1||fieldname2, MaybeMoreFields
from ::dbf_alias::tablename

for copy

insert into ::mySQL_Alias::tablename (MayBeFieldList)
select fieldname1||fieldname2, MaybeMoreFields
from ::dbf_alias::tablename

meikl ;-)
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7156902
I still don't understand how to do that.

I have next MySql structure table :

CREATE TABLE nuke_encyclopedia_text (
  tid int(10) NOT NULL auto_increment,
  eid int(10) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  text text NOT NULL,
  counter int(10) NOT NULL default '0',
  PRIMARY KEY  (tid)
) TYPE=MyISAM;

In dbf I have next fields: 'Name', 'Width','Genre'( just for example ).

I wish to store name into title field and 'Width'+'Genre' into text field.


Increased to 300 points for working sample.
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 7156911
insert into ::mySQL_alias::nuke_encyclopedia_text (title,text) select name, width||genre from ::dbf_alias::dbf_tablename
0
 
LVL 1

Expert Comment

by:_MeSSiah_
ID: 7157567
I'm working on the sample application ...
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7158660
Wait then :)

Untill then I copy my dbf into a new dbf table where the fields use my rules and then with dbf2mysql program I convert the table.

But I still preffer a proffesional way ( a directly conversion ).
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7176327
MeSSiah_ , any news there ?
0
 
LVL 9

Author Comment

by:ginsonic
ID: 7808865
I will ask to delete this question
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7919859
ginsonic asked to have this question closed. If there are no objections I will

  PAQ and refund the points

in 72 hours.
0
 
LVL 6

Accepted Solution

by:
Mindphaser earned 0 total points
ID: 7942416
Points refunded and moved to PAQ

** Mindphaser - Community Support Moderator **
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question