Solved

Dbf 2 MySql table

Posted on 2002-07-15
15
651 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
  • 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
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Virtuailstring tree compare node issue 14 116
oracle global variables 4 68
QRReport  TQrmemo vertical stretching 1 45
How to renew a Delphi rad-studio licence? 5 63
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…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

816 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now