MySQL Front: include "drop table" statements?

[aza]

Can anyone tell me what checkpoint for 'Include "DROP TABLE"-statements' mean when exporting tables from the databse?

TIA.

[HalfaBee]

I have never used that function.

But at a guess I would say it does a DROP TABLE before it creates the table.

That way when the data is imported if the table exists it is dropped and created so that only the data being imported is in the table.

HalfaBee

[aza]

Hmmm :rolleyes: ... I think it's a very good 'checkpoint' because I've met with such problem that when you simply copy DB, say from your forum (where all the tables left the same and only data in it changes), MySQL Front doesn't ovverwrite exisiting tables ...

[mikem]

I'm using MySQl Front also(unsupported):(

Anyway. I can't IMPORT .sql tables. Everytime I try, it gives me an error:
Error: 1064 - You have an error in your SQL syntax near '()' at line 1

I can export the tables as an .sql file, BUT you can only import CSV or .txt files. I tried changing my sql file to atxt file, but I still get the same error.

Anyone else know how to IMPORT the tabels using MySQL Front?

mikem

[HalfaBee]

To import tables as SQL click on the QUERY tab then the open folder button just above the query tab.
Enter your filename and press the RUN button.

HalfaBee