barneyf Posted February 19, 2009 Share Posted February 19, 2009 I want to backup my MySQL database so I tried the phpMyAdmin Export feature to save it as SQL commands in a text file. When I looked at the SQL file the table structure was there along with inserts to restore the data. But my INNODB table key constraints were missing. I found an old forum entry that mentioned unchecking "Data" to save the constraint info. I tried it and it worked. This seems odd, having to save two files. Is this how one really backs up a database? I presume that to restore the database, I would have to import the two files as well? Link to comment https://forums.phpfreaks.com/topic/146014-exporting-with-phpmyadmin/ Share on other sites More sharing options...
mjahkoh Posted February 20, 2009 Share Posted February 20, 2009 With Navicat or Mysql yog is a breeze Link to comment https://forums.phpfreaks.com/topic/146014-exporting-with-phpmyadmin/#findComment-767054 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.