?
Solved

Dbf 2 MySql table

Posted on 2002-07-15
15
Medium Priority
?
659 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Technology Partners: 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!

Question has a verified solution.

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

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

650 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