Import mysql from 5.1.70 to 5.5.32

mario2000 · 2013-11-24 16:53:02

Hi

Y have change the server:
Old server: mysql 5.1.70
New server: mysql 5.5.32
---------------------------
After import the old DB I get blank pages (all pages)

I need to know if this new version of mysql is suported by ASpro, and how i can make working the old db in the new server.

Thanks

symtab · 2013-11-25 10:05:17

Its 100% supported. I always use the latest version when i work on ASP. Currently i'm using:

[symtab@mybox ~]$ mysql --version
mysql  Ver 14.14 Distrib 5.5.30, for Linux (x86_64) using readline 5.1
[symtab@mybox ~]$

mario2000 · 2013-11-27 23:36:18

Thanks, but if you import the old 5.1 to other server with 5.5 , you get some errors.
I have created an new DB and i have copy and paste all tables content (just content)
-------------------------------
Also, in the old DB structure i have this `wmuser_comments`:
INSERT INTO `wmuser_comments` (`comment_id`, `parent_id`, `user_id`, `poster_id`, `ip`, `comment`, `add_date`, `status`, `spam`, `nickname`) VALUES
----------
the last column `nickname` - is mising in the 1.0.8 (new install)

I dont know if is an error, or not (all work ok), is mor for simtab, if have forget to add this column in the 1.0.8 instaler.

symtab · 2013-11-29 12:56:39

Its a bug. I will fix it in 1.0.9. Its missing from the sql file.

mario2000 · 2013-11-29 13:36:16

So I have to add this mising column by adding the entire table?

--
-- Estructura de tabla para la tabla `wmuser_comments`
--

CREATE TABLE IF NOT EXISTS `wmuser_comments` (
  `comment_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) unsigned NOT NULL DEFAULT '0',
  `user_id` int(11) unsigned NOT NULL DEFAULT '0',
  `poster_id` int(11) unsigned NOT NULL DEFAULT '0',
  `ip` int(10) NOT NULL DEFAULT '0',
  `comment` text NOT NULL,
  `add_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` enum('0','1') NOT NULL DEFAULT '1',
  `spam` int(11) unsigned NOT NULL DEFAULT '0',
  `nickname` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`comment_id`),
  KEY `parent_id` (`parent_id`),
  KEY `user_id` (`user_id`),
  KEY `poster_id` (`poster_id`),
  KEY `ip` (`ip`),
  KEY `status` (`status`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=83 ;

symtab · 2013-11-29 13:40:53

You can do:

ALTER TABLE `wmuser_comments` ADD `nickname` varchar(100) NOT NULL DEFAULT '';

mario2000 · 2013-11-29 13:59:16

Thanks, I will do this.

Adult Script Pro Community Forums

#1 2013-11-24 16:53:02

Import mysql from 5.1.70 to 5.5.32

#2 2013-11-25 10:05:17

Re: Import mysql from 5.1.70 to 5.5.32

#3 2013-11-27 23:36:18

Re: Import mysql from 5.1.70 to 5.5.32

#4 2013-11-29 12:56:39

Re: Import mysql from 5.1.70 to 5.5.32

#5 2013-11-29 13:36:16

Re: Import mysql from 5.1.70 to 5.5.32

#6 2013-11-29 13:40:53

Re: Import mysql from 5.1.70 to 5.5.32

#7 2013-11-29 13:59:16

Re: Import mysql from 5.1.70 to 5.5.32

Board footer