我尝试将一些数据导入我的localhost项目,我不知道该怎么做。 我现在的任务看起来像这样:
desc "imports the devel databse dump file to www2_sw" task :dumpimport => :environment do puts "Loading www2_sw_development_dump.sql. Enter mysql root password. Just press Enter for none" `sqlite3 development.sqlite3 < db/sql/geo_cities_states.sql` end但我有错误:
Error: near line 5: near "AUTO_INCREMENT": syntax error Error: near line 22: no such table: cities Error: near line 573: no such table: cities Error: near line 904: near "AUTO_INCREMENT": syntax error Error: near line 914: no such table: states问题是我的开发数据库中有这样的表。 我做错了什么? 如何将my_database.sql导入localhost开发数据库。
I try to import some data to my localhost project and i dont know what to do. My task for this look like this right now:
desc "imports the devel databse dump file to www2_sw" task :dumpimport => :environment do puts "Loading www2_sw_development_dump.sql. Enter mysql root password. Just press Enter for none" `sqlite3 development.sqlite3 < db/sql/geo_cities_states.sql` endBut i have error:
Error: near line 5: near "AUTO_INCREMENT": syntax error Error: near line 22: no such table: cities Error: near line 573: no such table: cities Error: near line 904: near "AUTO_INCREMENT": syntax error Error: near line 914: no such table: statesProblem is that there is such table in my development database. What i do wrong? How can i import my_database.sql to localhost development database.
最满意答案
这不是Rake或Ruby on Rails错误。 您是否尝试在命令行上运行该命令?
问题是您正在尝试将MYSQL或PostgreSQL转储导入SQLite。
我不认为SQLite理解AUTO_INCREMENT - 我认为它应该是AUTOINCREMENT ( SQLite AutoInc )
尝试将数据库更改为PostgreSQL或将转储修改为SQLite兼容。
This isn't a Rake or Ruby on Rails error. Have you tried running that command on the command line?
The problem is that you're trying to import a MYSQL or PostgreSQL dump into SQLite.
I don't think SQLite understands AUTO_INCREMENT - I believe it should be AUTOINCREMENT (SQLite AutoInc)
Try changing your DB to PostgreSQL or modify the dump to be SQLite compatible.
更多推荐
发布评论