Welcome to the Linux Foundation Forum!
upgrade my website without disturbing current load
kushallinux
Posts: 30
Hi All,
I am working as Linux administrator.
I want to upgrade my website .
My web site is imade in eZ publish.
my database is in phpmyadmin
I want to modify my database.
what should i do for modifying my database?
Thanks
Kushal
0
Comments
-
phpmyadmin is just an administrative console. Most likely your database is under mysql, you should be able to read to mysql manual to learn the correct syntax to modify your records and tables.0
-
but i dont know mysql .0
-
w3schools is very useful for anything related to web design. They show how to use most of the basic functions you would need for any SQL database server. I also use phpmyadmin and its very good. it depends on what you want to change but it shouldn't effect your website to much for must things you would want to do. Unless you drop a table
.
0 -
how can i modify database on phpmyadmin ?0
-
Hi Kushai,
How do you want to modify your database?. Do you mean upgrade or change the schema, or do you mean change the database type??
Most RPM based upgrades are pretty quick. what is the traffic like to your site. could it suffer a 'blip'?
If you mean upgrade whilst running your mileage may vary using several different approaches, what is the main balance of traffic to your site, is it more reads or writes? Can your site function in a read only manner for a small period of time?:
you could create a readonly MySQL replica (slave) on the same server using mysqld_multi(or do a dual install of MySQL). present the slave port to your web frontend.
Do the upgrade on your original MySQL server in the meantime. Drop the replica and repoint your webserver at the original MySQL port.
I've done this in several installations where appropriate and its worked great!
Another thing you could look into is caching the main pages to your site.0 -
@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?0 -
0
-
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
Matt0 -
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 .0 -
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.0
-
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 working0 -
I am getting this error after upgrading eZpublish version from 4.3 to 4.5
EZSW-004
Failed inserting data to mysql
Table 'ezapprove_items' already exists0 -
That is a very literal error message, the upgrade is attempting to build a new table under the same name as an existing table. There are numerous ways to work around this depending on the potential for table structure changes. I recommend replicating the table to a new name, deleting the existing table, allowing the script to create the new table then appending the data from the old table to the new one.0
-
i did this thing ...after that i am facing same problem for 3 more table .......then again same table error come0
-
At this point it sounds like you are using an installation script rather than an upgrade script. The difference is that an installer will attempt to build a new structure which yours is doing and an upgrade script will only modify the tables to the new format.
If what you are attempting to do is following the upgrade script from the project then I recommend contacting the project developers to alert them of the issue so they can work with you to find a stable solution.0 -
I had downloaded eZpublish 4.5 version from internet
then i had overwrite it in my folder "/var/www/testeZ/"
then when i access my site
"http://192.168.1.206/testeZ/index.php"
it is showing setup wizard .............at the end i got this error
EZSW-004
Failed inserting data to mysql
Table 'ezapprove_items' already exists
I am not understanding difference between installation script and upgrade script.0 -
Site info:
Site package - plain_site
Title - Plain site
URL - http://192.168.1.206/testeZ/index.php/plain_site
Admin URL - http://192.168.1.206/testeZ/index.php/plain_site_admin
Access type - url
Access value - plain_site
Web server info:
Version - Apache/2.2.3 (Red Hat)
PHP info:
Version - 5.3.4
OS info
Name - Linux linserver2.jzero.com 2.6.18-194.el5PAE #1 SMP Tue Mar 16 22:00:21 EDT 2010 i686
CPU Type - Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz
CPU Speed - 1600.000 MHz
Memory Size - 4212879360 (3.92 GB)
Database info:
Type - MySQL Improved
Driver - ezmysqli
Email info:
Transport - sendmail
Image conversion:
ImageMagick was found and used.
Path - /usr/bin
Executable - convert
ImageGD extension was found and used.
Regional info:
Primary - eng-US
Additional - eng-US
Critical tests
directory_permissions - Success
phpversion - Success
database_extensions - Success
image_conversion - Success
safe_mode - Success
memory_limit - Success
execution_time - Success
magic_quotes_runtime - Success
allow_url_fopen - Success
accept_path_info - Success
php_session - Success
file_upload - Success
zlib_extension - Success
dom_extension - Success
iconv_extension - Success
mbstring_extension - Success
timezone - Success
ezcversion - Success
Other tests:
variables_order - Failure
php_magicquotes - Success
curl_extension - Success
imagegd_extension - Success
imagemagick_program - Success
database_all_extensions - Success
php_register_globals - Success
texttoimage_functions - Success
open_basedir - Success0 -
plz tell me how can i solve this problem >?0
-
i got this error during eZpublish upgradation from 4.3 to 4.5
EZSW-004
Failed inserting data to mysql
Table 'ezapprove_items' already exists0 -
You can start by reading the official upgrade documentation at Ezpublish's website at http://doc.ez.no/eZ-Publish/Upgrading , most likely you will need to perform two upgrades, 4.3 -> 4.4 and 4.4 -> 4.50
-
I have already gone though this link
i am not getting ezpublish 4.4 version0 -
please reply me soon ........its urgent0
-
kushallinux wrote:I have already gone though this link
i am not getting ezpublish 4.4 version
If you had run the scripts in the upgrade documentation, then you would not have gotten error referring to created pre-existing tables. Due to the unknown differences between the 4.3, 4.4 and 4.5, it is recommended to do incremental upgrades from 4.3 to 4.5 to guarantee that all necessary changes have been made.
Since I am not a paying customer for this software like yourself, I can only recommend actions based upon the information given. Your current list of changes appears to have differed from their recommend actions. Hopefully with the purchase of the software license you have included support, I recommend contacting the company through their inquiry submission form at http://ez.no/Requests/Contact-Us to request their assistance with your problem, they should be able to patiently walk you through the necessary modifications.0 -
i hv already sent them my qurey ...but no reply0
-
kushallinux wrote:i hv already sent them my qurey ...but no reply
Have you attempted to call their contact phone numbers from the bottom of their website?0 -
No , its international call0
-
With paid software it is much harder to find assistance because only paid customers have access to the complete code, database structure and required libraries to properly analyze the issues and potential resolutions. Unfortunately I am unwilling to pay for software to assist a company's customer when their support has failed.
At this point because you have already shown us the error message stating that the configuration is damaged, I would recommend copying the past schema tables into a new schema, removing the old schema and all code from Ezpublish, reinstalling everything then attempting to populate the new schema tables with the old data. This is not the easiest or cleanest method and it is possible that the old data will not work in the new format, but without official support you are left with very few alternatives.0 -
Or you can pay a local IT professional as a consultant to work on resolving the issues for you.0
-
actually my company is taken me to solve linux related problems
so i cant heir any consultant0 -
kushallinux wrote:actually my company is taken me to solve linux related problems
so i cant heir any consultant
No ofense man but... they might need to to hire someone else. I don't mean to be rude, just pointing the obvious.
That or... work, work,work, work, work. And when you think you've got it all managed: work harder!!!
Regards0
Categories
- 10.2K All Categories
- 36 LFX Mentorship
- 89 LFX Mentorship: Linux Kernel
- 505 Linux Foundation Boot Camps
- 279 Cloud Engineer Boot Camp
- 104 Advanced Cloud Engineer Boot Camp
- 48 DevOps Engineer Boot Camp
- 41 Cloud Native Developer Boot Camp
- 2 Express Training Courses
- 2 Express Courses - Discussion Forum
- 1.8K Training Courses
- 17 LFC110 Class Forum
- 5 LFC131 Class Forum
- 20 LFD102 Class Forum
- 148 LFD103 Class Forum
- 13 LFD121 Class Forum
- 61 LFD201 Class Forum
- LFD210 Class Forum
- 1 LFD213 Class Forum - Discontinued
- 128 LFD232 Class Forum
- 23 LFD254 Class Forum
- 570 LFD259 Class Forum
- 100 LFD272 Class Forum
- 1 LFD272-JP クラス フォーラム
- 1 LFS145 Class Forum
- 23 LFS200 Class Forum
- 739 LFS201 Class Forum
- 1 LFS201-JP クラス フォーラム
- 1 LFS203 Class Forum
- 46 LFS207 Class Forum
- 298 LFS211 Class Forum
- 53 LFS216 Class Forum
- 46 LFS241 Class Forum
- 41 LFS242 Class Forum
- 37 LFS243 Class Forum
- 10 LFS244 Class Forum
- 27 LFS250 Class Forum
- 1 LFS250-JP クラス フォーラム
- 131 LFS253 Class Forum
- 998 LFS258 Class Forum
- 10 LFS258-JP クラス フォーラム
- 87 LFS260 Class Forum
- 126 LFS261 Class Forum
- 31 LFS262 Class Forum
- 79 LFS263 Class Forum
- 15 LFS264 Class Forum
- 10 LFS266 Class Forum
- 17 LFS267 Class Forum
- 17 LFS268 Class Forum
- 21 LFS269 Class Forum
- 201 LFS272 Class Forum
- 1 LFS272-JP クラス フォーラム
- 212 LFW211 Class Forum
- 154 LFW212 Class Forum
- 899 Hardware
- 217 Drivers
- 74 I/O Devices
- 44 Monitors
- 115 Multimedia
- 208 Networking
- 101 Printers & Scanners
- 85 Storage
- 749 Linux Distributions
- 88 Debian
- 64 Fedora
- 14 Linux Mint
- 13 Mageia
- 24 openSUSE
- 133 Red Hat Enterprise
- 33 Slackware
- 13 SUSE Enterprise
- 355 Ubuntu
- 473 Linux System Administration
- 38 Cloud Computing
- 69 Command Line/Scripting
- Github systems admin projects
- 94 Linux Security
- 77 Network Management
- 108 System Management
- 49 Web Management
- 63 Mobile Computing
- 22 Android
- 27 Development
- 1.2K New to Linux
- 1.1K Getting Started with Linux
- 528 Off Topic
- 127 Introductions
- 213 Small Talk
- 20 Study Material
- 796 Programming and Development
- 264 Kernel Development
- 498 Software Development
- 923 Software
- 258 Applications
- 182 Command Line
- 2 Compiling/Installing
- 76 Games
- 316 Installation
- 54 All In Program
- 54 All In Forum
Upcoming Training
-
August 20, 2018
Kubernetes Administration (LFS458)
-
August 20, 2018
Linux System Administration (LFS301)
-
August 27, 2018
Open Source Virtualization (LFS462)
-
August 27, 2018
Linux Kernel Debugging and Security (LFD440)