How to Upgrade to MySQL 5.0

A Member? Please Login  
type your username and password to login
Date: October 08, 2008, 04:27 AM
247352 members and 146320 Topics
Latest Member: Lcjfyovi
Nairaland [Nigerian Forum] Home Help Search Who is currently online? Login Register
Nairaland Forum  |  Technology  |  Programming  |  How to Upgrade to MySQL 5.0
Pages: (1) Go Down Send this topic Notify of replies
Author Topic: How to Upgrade to MySQL 5.0  (Read 519 views)
timmy (m)
How to Upgrade to MySQL 5.0
« on: December 24, 2005, 07:55 PM »

 Grin question one. i do i upgrade my MySQL to version 5 without loosing my database and how can i connect to an external mysql from a different server..
layi (m)
Re: How to Upgrade to MySQL 5.0
« #1 on: December 25, 2005, 05:16 PM »

First Question
Here's how I would do upgrade from older versions:

* make a dump of all your data except the mysql database

* make a separate dump of the mysql database

* uninstall this old MySQL version

* install the latest MySQL version from scratch

* create a separate database for the previously dumped mysql database (e.g.
mysql_old) and restore this dump

* sync the old mysql database with the new one (this might require some
manual work, because the structures will be slightly different)

* when the new mysql database is OK, restore the dump of the data

If you have a chance, try to install the new version on a separate machine,
before you uninstall the old MySQL version to make sure that everythink works.

layi (m)
Re: How to Upgrade to MySQL 5.0
« #2 on: December 25, 2005, 05:25 PM »

Second Question:
Connecting Mql server form a Different server

Once you have the database name, username and password, you can connect to the database easily
Note that, depending on where it was created, your database may be on nairaland database servers for instance. If so you would have been given the name of the database server, for instance "db1.int.nairaland.com". In that case you should add an appropriate -h option to the command line:

$ mysql -h db1.int.nairaland.com -u username -p database-name
Enter password: enter your password; it won't be echoed
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 396905 to server version: 3.23.x

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


 About Oracle Database Express Edition  Bidding Software  What Is Adware.win32.hotbar.cc And Adware.win32.180 Solution  Page 2
Pages: (1) Go Up Send Topic to Friend by E-mail Reply 
Google
 
Web www.nairaland.com
Sections: TV/Movies (2) Music/Radio (2) Celebrities Job Talk Jobs/Vacancies (2) Career Talk Romance Books Politics Sports Fashion Travel
Health Schooling Religion General(2) Business Webmaster Programming Computers Phones Cars & Trucks

Links: Page1 Page2 Page3 Page4 Page5 Page6 Page7 Page8 Page9 Page10

Nairaland is owned by Oluwaseun Osewa
Nairaland Forum | Powered by SMF 1.0.12.
© 2001-2005, Lewis Media. All Rights Reserved.