Linux.com

Home Linux Community Forums Linux System Administration Web Management upgrade my website without disturbing current load

upgrade my website without disturbing current load

Link to this post 05 Apr 11

@mpalmeruk

thnkx

i want to upgrade database , i dont want to change its type .

we have heavy traffic on site

yes but how to do all this task ?
i mean how to create replica & all

how to create "readonly MySQL replica (slave) on the same server using mysqld_mult" ?

can u tell in detail?

how to do a dual install of MySQL?

Link to this post 05 Apr 11

@Sam Light

thnkx buddy
w3school is very useful to me
:)

Link to this post 05 Apr 11

Hi,

can you let me know your distro, whether u installed MySQL from source or RPM/apt-get. Which version of MySQL you are on currently and which version you are attempting to jump to.

thanks

Matt

Link to this post 05 Apr 11

Hi

my mysql version is MySQL 5.1.10


see we are using eZpublish version 4.3
Now i want to upgrade eZpublish version 4.5 without disturbing code & database .

Link to this post 05 Apr 11

You can setup a new schema with read-only rights for all but the admin, then you can dump the contents of the existing schema into the new schema with "mysqldump originalschema>mysql newschema". You may need to change the command slightly for your needs, so may sure to read the manual for mysqldump to find the applicable criteria.

Link to this post 07 Apr 11

Hi
my current site is using eZpublish 4.3 version
I upgraded its version to 4.5
but problem is that it is generating new database .
i want to work on my old database with new version 4.5
if i upload old database to new then my site is not working

Who we are ?

The Linux Foundation is a non-profit consortium dedicated to the growth of Linux.

More About the foundation...

Frequent Questions

Join / Linux Training / Board