Export WP Db from PhpMyAdmin then import into HeidiSQL

[expired user #4937]'s profile image [expired user #4937] posted 14 years ago in Import/Export Permalink
Does anyone have any ideas on how to export a WordPress Db through PhpMyAdmin then import it with HeidiSQL?

I can export a .sql file or a .csv file from PhpMyAdmin, but I can't seem to figure out the steps to getting it to import on my new box through HeidiSQL.

Any tips are welcomed!
ansgar's profile image ansgar posted 14 years ago Permalink
HeidiSQL can load .sql files into the query editor, then just press F9 to execute the whole batch.

CSV files can be imported via Import > "Import CSV file".

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