MySQL Forums
Forum List  »  MyISAM

Re: Memory Problem with 1 DB. Other DB ok
Posted by: Gabriel Dunn
Date: January 28, 2015 02:39PM

This is the create statement generated from the MySQL Wordpress table. I am only trying to select the ID column into MSSQL, not the entire table. Then I compare the IDs that I imported, against a MSSQL table. That step is all MSSQL and not a problem.

Any ID not in the uploaded table would be written back to the MySQL database with an insert statment.

CREATE TABLE `wp_users` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`user_login` varchar(60) NOT NULL default '',
`user_pass` varchar(64) NOT NULL default '',
`user_nicename` varchar(50) NOT NULL default '',
`user_email` varchar(100) NOT NULL default '',
`user_url` varchar(100) NOT NULL default '',
`user_registered` datetime NOT NULL default '0000-00-00 00:00:00',
`user_activation_key` varchar(60) NOT NULL default '',
`user_status` int(11) NOT NULL default '0',
`display_name` varchar(250) NOT NULL default '',
PRIMARY KEY (`ID`),
KEY `user_login_key` (`user_login`),
KEY `user_nicename` (`user_nicename`),
KEY `ID_Desc` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2904656 DEFAULT CHARSET=utf8;


Example INSERT to MySQL from MSSQL:

INSERT INTO web_prod.wp_users ( ID ,user_login ,user_pass ,user_nicename ,user_email ,user_url ,user_registered ,user_activation_key ,user_status ,display_name) VALUES ( 2904729 ,'member1' ,'' ,'Jon' ,'jonsmith@gmail.org' ,' ' ,'2015-01-28 15:17:35' ,' ' ,'2' ,'Jon Smith');

Options: ReplyQuote


Subject
Views
Written By
Posted
2808
January 22, 2015 11:15PM
Re: Memory Problem with 1 DB. Other DB ok
1288
January 28, 2015 02:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.