#1  
Old 15th October 2008, 20:10
misterm misterm is offline
Senior Member
 
Join Date: Aug 2005
Posts: 557
Thanks: 20
Thanked 8 Times in 7 Posts
Unhappy Update of RounCube SQL

Hello with all

I would like to carry out an update of RoundCube for the base of gives MYSQL

Quote:
mysql.update.sql
How to make under SSH, the command mysql

Good day MM
__________________
ISPConfig, the panel fantastic , http://www.ispconfig.be/forums/
http://www.ispconfig.be/
Reply With Quote
Sponsored Links
  #2  
Old 16th October 2008, 12:15
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,259
Thanks: 215
Thanked 648 Times in 294 Posts
Default

I i understand you well, you want the code to perform an update from a previous version. Here are the possibilities for MySQL:

For MySQL 4.0.x for a first fresh install:
------------------------------------------
mysql roundcubemail < SQL/mysql.initial.sql

For MySQL 4.0.x for an update from the previous version:
--------------------------------------------------------
mysql roundcubemail < SQL/mysql.update.sql


For MySQL 4.1.x/5.x for a first fresh install:
----------------------------------------------
mysql roundcubemail < SQL/mysql5.initial.sql


For MySQL 4.1.x/5.x for an update from the previous version:
------------------------------------------------------------
mysql roundcubemail < SQL/mysql.update.sql

The SQL files can be found within the SQL directory which comes with RoundCube.
Read the INSTALL file which comes with RoundCube for more information.

Of course you also can use phpMyAdmin to do this job.
__________________
Hans

MrHostman | Master in managed hosting

Last edited by Hans; 26th October 2008 at 13:20.
Reply With Quote
  #3  
Old 20th October 2008, 14:49
misterm misterm is offline
Senior Member
 
Join Date: Aug 2005
Posts: 557
Thanks: 20
Thanked 8 Times in 7 Posts
Question

Hello Hans, in any case thank you, but doesn't your solution function?

Because j' have an error at the time of connection

You do not have another solution, of the kind, to make a backup, on the tables for example, is to introduce them into the new version?

Thank you Hans

MM
__________________
ISPConfig, the panel fantastic , http://www.ispconfig.be/forums/
http://www.ispconfig.be/
Reply With Quote
  #4  
Old 20th October 2008, 16:25
misterm misterm is offline
Senior Member
 
Join Date: Aug 2005
Posts: 557
Thanks: 20
Thanked 8 Times in 7 Posts
Question You are on Hans that…

Hans, you is on that this file which is " mysql5.update" this finds well in repertory SQL, because when I list this same repertory, it this does not find…

Quote:
-rw-r--r-- 1 web67_XXXXXX web67 7608 2007-09-19 08:55 mssql.initial.sql
-rw-r--r-- 1 web67_XXXXXX web67 4214 2008-06-12 19:46 mysql5.initial.sql
-rw-r--r-- 1 web67_XXXXXX web67 3812 2008-06-12 19:46 mysql.initial.sql
-rw-r--r-- 1 web67_XXXXXX web67 869 2008-06-12 19:46 mysql.update.sql
-rw-r--r-- 1 web67_XXXXXX web67 5228 2008-06-12 19:46 postgres.initial.sql
-rw-r--r-- 1 web67_XXXXXX web67 1195 2008-06-12 19:46 postgres.update.sql
-rw-r--r-- 1 web67_XXXXXX web67 3580 2008-06-12 19:46 sqlite.initial.sql
-rw-r--r-- 1 web67_XXXXXX web67 1018 2008-06-12 19:46 sqlite.update.sql
MM
__________________
ISPConfig, the panel fantastic , http://www.ispconfig.be/forums/
http://www.ispconfig.be/
Reply With Quote
  #5  
Old 26th October 2008, 13:20
Hans Hans is offline
Moderator
 
Join Date: Dec 2005
Location: Montfoort, The Netherlands
Posts: 2,259
Thanks: 215
Thanked 648 Times in 294 Posts
 
Default

The right command should be:
mysql roundcubemail < SQL/mysql.update.sql

For further upgrade instructions, please have a look to the text file "UPGRADING" which comes with RoundCube.
__________________
Hans

MrHostman | Master in managed hosting
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to build packages that can be installed with the ISPConfig update function. till Tips/Tricks/Mods 3 18th February 2008 13:10
High Availability Samba cluster - DRBD + Heartbeat djalex Server Operation 58 25th May 2007 19:38
postfix-tls sasl2 mysql courier-authmysql gabrix Server Operation 4 12th January 2007 22:09
php 5.2.0 update! cybereatl Installation/Configuration 1 15th November 2006 09:22
HotSaNIC domino Tips/Tricks/Mods 23 6th November 2006 05:19


All times are GMT +2. The time now is 22:46.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.