Created
February 12, 2011 17:37
-
-
Save rcreasey/823900 to your computer and use it in GitHub Desktop.
Trying to figure out what's happening when doing a db pull from one mysql db to another.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mysql> explain wp_users; | |
| +---------------------+---------------------+------+-----+---------------------+----------------+ | |
| | Field | Type | Null | Key | Default | Extra | | |
| +---------------------+---------------------+------+-----+---------------------+----------------+ | |
| | ID | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | |
| | user_login | varchar(60) | NO | MUL | | | | |
| | user_pass | varchar(64) | NO | | | | | |
| | user_nicename | varchar(50) | NO | MUL | | | | |
| | user_email | varchar(100) | NO | | | | | |
| | user_url | varchar(100) | NO | | | | | |
| | user_registered | datetime | NO | | 0000-00-00 00:00:00 | | | |
| | user_activation_key | varchar(60) | NO | | | | | |
| | user_status | int(11) | NO | | 0 | | | |
| | display_name | varchar(250) | NO | | | | | |
| +---------------------+---------------------+------+-----+---------------------+----------------+ | |
| 10 rows in set (0.00 sec) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/adapters/mysql2.rb:91:in `query': Mysql2::Error: Incorrect column specifier for column 'ID' (Sequel::DatabaseError) | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/adapters/mysql2.rb:91:in `block in _execute' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/logging.rb:28:in `log_yield' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/adapters/mysql2.rb:91:in `_execute' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/adapters/mysql2.rb:74:in `block in execute' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/connection_pool/threaded.rb:84:in `hold' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/connecting.rb:226:in `synchronize' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/adapters/mysql2.rb:74:in `execute' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/query.rb:71:in `execute_dui' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/query.rb:64:in `execute_ddl' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/schema_methods.rb:320:in `create_table_from_generator' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/schema_methods.rb:94:in `create_table' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/extensions/migration.rb:52:in `method_missing' | |
| from (eval):3:in `up' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/extensions/migration.rb:33:in `apply' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/taps-0.3.15/lib/taps/schema.rb:64:in `block in load' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/database/connecting.rb:76:in `connect' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/sequel-3.17.0/lib/sequel/core.rb:119:in `connect' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/taps-0.3.15/lib/taps/schema.rb:61:in `load' | |
| from /Users/rcreasey/.rvm/gems/ruby-1.9.2-p136/gems/taps-0.3.15/bin/schema:44:in `<main>' |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Class.new(Sequel::Migration) do | |
| def up | |
| create_table("wp_users") do | |
| primary_key :ID, :type=>String | |
| String :user_login, :null=>false, :size=>60 | |
| String :user_pass, :null=>false, :size=>64 | |
| String :user_nicename, :null=>false, :size=>50 | |
| String :user_email, :null=>false, :size=>100 | |
| String :user_url, :null=>false, :size=>100 | |
| DateTime :user_registered, :null=>false | |
| String :user_activation_key, :null=>false, :size=>60 | |
| Integer :user_status, :default=>0, :null=>false | |
| String :display_name, :null=>false, :size=>250 | |
| end | |
| end | |
| def down | |
| drop_table("wp_users") if @db.table_exists?("wp_users") | |
| end | |
| end |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT * FROM `wp_users` LIMIT 1 | |
| CREATE TABLE `wp_users` (`ID` varchar(255) PRIMARY KEY AUTO_INCREMENT, `user_login` varchar(60) NOT NULL, `user_pass` varchar(64) NOT NULL, `user_nicename` varchar(50) NOT NULL, `user_email` varchar(100) NOT NULL, `user_url` varchar(100) NOT NULL, `user_registered` datetime NOT NULL, `user_activation_key` varchar(60) NOT NULL, `user_status` integer NOT NULL DEFAULT 0, `display_name` varchar(250) NOT NULL) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment