distal-attribute
distal-attribute
distal-attribute
distal-attribute

Export von Tabelleninhalten

User, date Message
Written by henkel_1111
8 years ago
Category: Import/Export
17 posts since Sat, 07 Oct 06
Hallo,

im alten MySQLFront konnte ich einfach Datens
Written by ansgar
8 years ago
5009 posts since Fri, 07 Apr 06
Think I reply in english so all users can read it. surprised

The message "Access denied for user..." shows me that you need some privileges which you do not have currently. You should specify more details so we can help you in that point.

The options in export-tables have moved to a new tabsheet because there were some new ones which needed more space. You can't do everything on one page, that's not possible, sorry. Beyond other options it is new that you now can either
A: 1) delete all existing data (truncate) and 2) insert normally
B: insert newer data, while ignoring existing records
C: insert newer data, plus update existing records, which is following your primary or unique keys

As you can see, in comparison to MySQL-Front 2.5 you have some powerful new features here, which can synchronize your data reliable.
Written by henkel_1111
8 years ago
17 posts since Sat, 07 Oct 06
hi anse,

you are right the options are very good and copying data works fine as far as i can see.

but i still have the problem with creating tables. error: "you have an error in your sql syntax near ';'. the only ";" is at the end: type=myisam;
any ideas? mysql-server is 4.0.17
Written by ansgar
8 years ago
5009 posts since Fri, 07 Apr 06
David has generated one bug-report and one feature-request from your infos:
http://sourceforge.net/support/tracker.php?aid=1576248
http://sourceforge.net/support/tracker.php?aid=1576243

We discussed that issue with the hidden options and came to the conclusion - ok, David had the ideasmile- to make a wizard with some steps (we will start with 2), instead of squeezing just everything onto one single form. The first screen will only ask for the source-db/tables, the second will have the rest: options and output-"method". Good?

The bugreport is related to the superflous semicolon - should be fixed soon.
Written by ansgar
8 years ago
5009 posts since Fri, 07 Apr 06
hey, David is lightning fast (as always): The bug with the SQL-semicolon is fixed and closed since this night at 01:27 :

http://sourceforge.net/support/tracker.php?aid=1576243
Written by henkel_1111
8 years ago
17 posts since Sat, 07 Oct 06
hi anse,

thats great. when will be the next release with the bug fixed?
thanks a lot in advance.
Written by ansgar
8 years ago
5009 posts since Fri, 07 Apr 06
hopefully in november.
Written by henkel_1111
8 years ago
17 posts since Sat, 07 Oct 06
do you have any hints how to change the create-command manually in the meantime???
Written by ansgar
8 years ago
5009 posts since Fri, 07 Apr 06
No - sorry, unfortunately you have to wait for the next release.
Written by ansgar
8 years ago
5009 posts since Fri, 07 Apr 06
ah you could just export to a file, and import from that file?
 

Please login to leave a reply, or register at first.