Upon Export, Old Table/Field Names are Listed in Export

designsbycm's profile image designsbycm posted 1 week ago in Import/Export Permalink

Hi there. I exported my database sql file and the old table and field names were listed in the file. Anything that can be done to fix this problem?

ansgar's profile image ansgar posted 7 days ago Permalink

So you created the SQL export file, and then you changed your table and field names?

Please be more precise about the problem.

designsbycm's profile image designsbycm posted 7 days ago Permalink

Sorry! I was sooooo tired yesterday that I was brain dead. ha!

So ... I changed table names and field names in Heidi. Then, I exported the database to an sql file. I opened it up and the OLD table and field names were in that file. I restarted Heidi and tried multiple times, but still the same export with the old names.

Also, after changing the table and field names in Heidi, and trying to save my changes, I had various errors popup warning that the old field name was not present. ha! I had to go login to the server and get the changes actually made.

Thanks for any help you might have! I've always done the structure manipulation via PHPMyAdmin on the server, but just found this software a couple days ago and it's REAL nifty and much quicker. :)

ansgar's profile image ansgar posted 6 days ago Permalink

Thanks for your feedback. Glad you nailed it!

alan4910's profile image alan4910 posted 6 days ago Permalink

To address a related issue, HeidiSQL seems to have trouble remembering file names when exporting data. For example, if I have four databases to back up, with the following paths and names, HeidiSQL will only remember D:\quotation-2026-06-05.sql, not the others. This forces me to re-enter the file names every time I need to back up the data the next day. I believe this problem started about two or three months ago but hasn't been fixed. I'm reporting this to you now, thank you.

Database file names: D:\discuz-2026-06-05.sql D:\manage-2026-06-05.sql D:\maintain-2026-06-05.sql D:\quotation-2026-06-05.sql

ansgar's profile image ansgar posted 6 days ago Permalink

No problem here, just tested:

grafik.png

designsbycm's profile image designsbycm posted 6 days ago Permalink

Hi there. Thanks. But, I was referring to the database FIELD names, not the exported FILE name. :)

ansgar's profile image ansgar posted 6 days ago Permalink

@designsbycm: Yes, understood. My reply was meant for alan4910's comment.

designsbycm's profile image designsbycm posted 6 days ago Permalink

Oh ok. ha! Thanks!

designsbycm's profile image designsbycm posted 6 days ago Permalink

Hey ansgar ... would you happen to know of a good CRUD generator that has the ability for image/file uploads built into it for textarea fields?

ansgar's profile image ansgar posted 6 days ago Permalink

Just doing support for HeidiSQL here. You may insert images with the built-in file processor.

designsbycm's profile image designsbycm posted 6 days ago Permalink

Oh! Ok ... thank you. :)

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