After dumping some MySQL tables, whose the structure is the follwing:
CREATE TABLE `mydata` (
`id` tinyint(10) NOT NULL auto_increment,
`content` varchar(20) NOT NULL default ‘’,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
INSERT INTO `mydata` VALUES (’1′, ‘First entry’);
etc.
After dumping the tables, you want to drop the original tables from the database in order to replace the content; however, […]
My hosting’s MySQL server was diown yesterday (too many connections). Apparantly, they could fix that problem; I thought of migrating the backup’ed data temporarily to another MySQL server but everything works fine now.
©2005-2008 Swobodin
This work is licensed under a Creative Commons Attribution-ShareAlike 2.5 License.
Swobodin v Brně is proudly powered by
WordPress
Entries (RSS)
and Comments (RSS).
No proprietary softwares were used, no castles were burned and no animals were harmed for the publication of this blog.