Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Export to another database

grahamjb's profile image grahamjb posted 1 month ago in General Permalink

I am trying to export around 100 tables to another newly created database by selecting tools export then selecting the database I want to copy to.

Previously all selected tables copied fine, but now, with recent builds for a few weeks, only some tables copy.

Many others fail reporting ERROR 1067 - Invalid default value for XXXX

All default values are correct and save correctly, but they just wont copy. Database is MariaDB

ansgar's profile image ansgar posted 1 month ago Permalink

That's probably a build where I composed the CREATE TABLE code from the internal column and key queries. I reverted that, so now this should be again the result of SHOW CREATE TABLE xyz, which is more compatible. Please update to the latest build. And please report which revision you are using.

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