Export von Tabelleninhalten

[expired user #255]'s profile image [expired user #255] posted 17 years ago in Import/Export Permalink
Hallo,

im alten MySQLFront konnte ich einfach Datens
ansgar's profile image ansgar posted 17 years ago Permalink
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.
[expired user #255]'s profile image [expired user #255] posted 17 years ago Permalink
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
ansgar's profile image ansgar posted 17 years ago Permalink
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.
ansgar's profile image ansgar posted 17 years ago Permalink
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
[expired user #255]'s profile image [expired user #255] posted 17 years ago Permalink
hi anse,

thats great. when will be the next release with the bug fixed?
thanks a lot in advance.
ansgar's profile image ansgar posted 17 years ago Permalink
hopefully in november.
[expired user #255]'s profile image [expired user #255] posted 17 years ago Permalink
do you have any hints how to change the create-command manually in the meantime???
ansgar's profile image ansgar posted 17 years ago Permalink
No - sorry, unfortunately you have to wait for the next release.
ansgar's profile image ansgar posted 17 years ago Permalink
ah you could just export to a file, and import from that file?

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