Saturday, December 31, 2005

The solution of mysql Convertion between version 4 to 5.

Download latest Version of PhpMyAdmin[phpMyAdmin-2.7.0-pl2.zip] click on the left box zip version.

1.config.default.php , file having the configuration of the Database change to your Destination Database live server.
Note:PhpMyAdmin mainly used for to contact localhost by Default.
2.Export your Database to SQLFile.
3.Open the SQLFile in Editplus.
note: Editplus is the Low waitage for RAM.


Heres the example of the Database.
--------------------------------
# Table structure for table 'admin'
#

CREATE TABLE admin (
uid int(8) NOT NULL auto_increment,
user_name varchar(50) character set latin1 default NULL,
user_pwd varchar(50) character set latin1 default NULL,
PRIMARY KEY (uid)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--------------------------------

4.Remove the Statement of following:
>character set latin1 default
>ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci

5.Copy the Statement query to PhpMyAdmin feed little by little , to create the structures & data in the Live Server

No comments:

Adobe News