upgrading to mysql 5

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
pedrotuga
Forum Contributor
Posts: 249
Joined: Tue Dec 13, 2005 11:08 pm

upgrading to mysql 5

Post by pedrotuga »

i am currently using mysql4 on debian (ubuntu), i need to update to mysql5, i heard i need to recompile php... do i?

cant i simply install them using apt

or update maybe... like

Code: Select all

sudo apt-get update mysql
will i lose my datatabases? (they are backed up anyway)
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Updating should not so anything to your current databases. But, to be sure, you should carry a back up. The only thing that might be affected in PHP by a MySQL upgrade is the MySQL client API version.
User avatar
pedrotuga
Forum Contributor
Posts: 249
Joined: Tue Dec 13, 2005 11:08 pm

Post by pedrotuga »

Everah wrote:Updating should not so anything to your current databases. But, to be sure, you should carry a back up. The only thing that might be affected in PHP by a MySQL upgrade is the MySQL client API version.
lets check up if works then
User avatar
pedrotuga
Forum Contributor
Posts: 249
Joined: Tue Dec 13, 2005 11:08 pm

Post by pedrotuga »

mmm... a stupid question... how do i turn off mysql-server?
User avatar
darodesign
Forum Newbie
Posts: 19
Joined: Mon Aug 28, 2006 8:58 am
Location: Berlin
Contact:

Post by darodesign »

-path-to-your-mysql-binary/bin/mysqld stop

or killall mysqld ( mysqld_safe )
path to your mysql bin you casn get with whereis mysql.
User avatar
pedrotuga
Forum Contributor
Posts: 249
Joined: Tue Dec 13, 2005 11:08 pm

Post by pedrotuga »

darodesign wrote:-path-to-your-mysql-binary/bin/mysqld stop

or killall mysqld ( mysqld_safe )
path to your mysql bin you casn get with whereis mysql.
thanks
Post Reply