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? Quote 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? Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/37895-exporting-database/#findComment-182267 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.