trip272 Posted February 10, 2007 Share Posted February 10, 2007 I exported my database with phpMyAdmin and tried to import it to my new server but I got this error. Error SQL-query : LOAD DATA LOCAL INFILE '/tmp/phpAZaYSX' REPLACE INTO TABLE `speech` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' MySQL said: The used command is not allowed with this MySQL version I think it's because the MYSQL versions must be different but how can I export it to be most compatible? Link to comment https://forums.phpfreaks.com/topic/37895-exporting-database/ Share on other sites More sharing options...
effigy Posted February 10, 2007 Share Posted February 10, 2007 Have you tried mysqldump? What versions are the old/new servers using? Link to comment https://forums.phpfreaks.com/topic/37895-exporting-database/#findComment-181419 Share on other sites More sharing options...
fenway Posted February 11, 2007 Share Posted February 11, 2007 LOAD is one of the priviledges. Link to comment https://forums.phpfreaks.com/topic/37895-exporting-database/#findComment-182267 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.