Re: upgrade mysql 3.23.58 to 4.1
Hassan Schroeder wrote: mm wrote: There is a lot a pain here. I downloaded the rpm packages that's where the pain starts :-) If you're trying to run multiple versions of MySQL for pre-migration testing (or whatever), *don't use rpms* -- get the tar file of the binary, and just untar it as /usr/local/mysql-4.1.12 or whatever. It will be *so* much simpler to switch between the old and new, or run them simultaneously as needed. FWIW! Thanks a lot. Now I have 2 folders with 4.0 and 4.1 distribution. (/usr/local/mysql40, /usr/local/mysql41) They said to upgrade from 3.23 to 4.0 and then from 4.0 to 4.1 2.7 Installing MySQL on Other Unix-Like Systems ... 6. If you haven't installed MySQL before, you must create the MySQL grant tables: what about 'Else' ? --- Finally I did start the server and mysql 4.0 with my database. I did this by running my script mount-mysql [EMAIL PROTECTED] mircea]# ./mount-mysql [EMAIL PROTECTED] mircea]# Starting mysqld daemon with databases from /var/lib/mysql mount-mysql: mount --bind /mnt/120GB/mysql5 /var/lib/mysql cd /usr/local/mysql40 ; /usr/local/mysql40/bin/safe_mysqld & [EMAIL PROTECTED] ~]$ /usr/local/mysql40/bin/mysql -u mircea -psome_pass -S/var/lib/mysql/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.0.24-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Now, as I am yang in Linux, wish to understand what it is all about in: mysql_install_db mysql.server mysql_setpermission mysqld_safe safe_mysqld mysqlaccess mysqlbug I have to read about bash suppose. Thank you Hassan, Kishore, Gleb, and others for your help! mt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade mysql 3.23.58 to 4.1
mm wrote: There is a lot a pain here. I downloaded the rpm packages that's where the pain starts :-) If you're trying to run multiple versions of MySQL for pre-migration testing (or whatever), *don't use rpms* -- get the tar file of the binary, and just untar it as /usr/local/mysql-4.1.12 or whatever. It will be *so* much simpler to switch between the old and new, or run them simultaneously as needed. FWIW! -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade mysql 3.23.58 to 4.1
Selon mm <[EMAIL PROTECTED]>:
> Hi,
> There is a lot a pain here.
> I downloaded the rpm packages
> MySQL-server-4.1.12-1.i386.rpm
> MySQL-shared-4.1.12-1.i386.rpm
> MySQL-bench-4.1.12-1.i386.rpm
> MySQL-shared-compat-4.1.11-0.i386.rpm
> MySQL-client-4.1.12-1.i386.rpm
> MySQL-devel-4.1.12-1.i386.rpm
> MySQL-embedded-4.1.12-1.i386.rpm
> MySQL-Max-4.1.12-1.i386.rpm
>
> Maximum RPM said:
> ---
> rpm -qp --queryformat "%{defaultprefix}\n"
> Just replace with the name of the package file you want to
> check out. If the package is not relocatable, you'll only see the word
> (none).
>
> This doesn't work.
> --
> [EMAIL PROTECTED] MySQL]$ rpm -qp --queryformat "%{defaultprefix}\n"
> MySQL-Max-4.1.12-1.i386.rpm
> warning: MySQL-Max-4.1.12-1.i386.rpm: V3 DSA signature: NOKEY, key ID
> 5072e1f5
> error: incorrect format: unknown tag
>
> The MD5 check sum was OK bat "Signature Checking Using RPM" was not.
> ---
>
> My Linux experience is short so I have to read a lot for every movement.
> If you can gave me more help ti will be easier for me.
> Thanks,
> MT
>
>
>
> Kishore Jalleda wrote:
>
> >Yes You can have both versions, infact this is the preferred way to
> >upgrade, but the only thing is that have the new version install in
> >/usr/local/mysql2/ or what ever you want and change the port that the
> >newer daemon listens on instead of the default 3306, here's a good
> >link from the doc's of mysql...
> >http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html
> >
> >Hope this helps,
> >Kishore Jalleda
> >
> >On 6/24/05, mm <[EMAIL PROTECTED]> wrote:
> >
> >
> >>I have on my system, Fedora core 3, MySql 3.23.58
> >>Working with wikipedia database I get one error an one advise to upgrade
> >>to Mysql 4.xx
> >>Can I have old mySQL and the new one on my system?
> >>It is necessary to recreate databases and reload the data?
> >>What other kind of problem is suppose to find on my way during upgrade?
> >>Thanks,
> >>MT
> >>
> >>
> >>--
> >>MySQL General Mailing List
> >>For list archives: http://lists.mysql.com/mysql
> >>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> >>
> >>
> >>
> >>
> >
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
Hi, if you transfered them from windows to linux with ftp without binary, that
should be the reason.
just retransfer using binary mode.
ELse, i can't see.
have you tried an install of one of them ?
Hope that helps
:o)
Mathias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade mysql 3.23.58 to 4.1
Hi,
There is a lot a pain here.
I downloaded the rpm packages
MySQL-server-4.1.12-1.i386.rpm
MySQL-shared-4.1.12-1.i386.rpm
MySQL-bench-4.1.12-1.i386.rpm
MySQL-shared-compat-4.1.11-0.i386.rpm
MySQL-client-4.1.12-1.i386.rpm
MySQL-devel-4.1.12-1.i386.rpm
MySQL-embedded-4.1.12-1.i386.rpm
MySQL-Max-4.1.12-1.i386.rpm
Maximum RPM said:
---
rpm -qp --queryformat "%{defaultprefix}\n"
Just replace with the name of the package file you want to
check out. If the package is not relocatable, you'll only see the word
(none).
This doesn't work.
--
[EMAIL PROTECTED] MySQL]$ rpm -qp --queryformat "%{defaultprefix}\n"
MySQL-Max-4.1.12-1.i386.rpm
warning: MySQL-Max-4.1.12-1.i386.rpm: V3 DSA signature: NOKEY, key ID
5072e1f5
error: incorrect format: unknown tag
The MD5 check sum was OK bat "Signature Checking Using RPM" was not.
---
My Linux experience is short so I have to read a lot for every movement.
If you can gave me more help ti will be easier for me.
Thanks,
MT
Kishore Jalleda wrote:
Yes You can have both versions, infact this is the preferred way to
upgrade, but the only thing is that have the new version install in
/usr/local/mysql2/ or what ever you want and change the port that the
newer daemon listens on instead of the default 3306, here's a good
link from the doc's of mysql...
http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html
Hope this helps,
Kishore Jalleda
On 6/24/05, mm <[EMAIL PROTECTED]> wrote:
I have on my system, Fedora core 3, MySql 3.23.58
Working with wikipedia database I get one error an one advise to upgrade
to Mysql 4.xx
Can I have old mySQL and the new one on my system?
It is necessary to recreate databases and reload the data?
What other kind of problem is suppose to find on my way during upgrade?
Thanks,
MT
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade mysql 3.23.58 to 4.1
Hello. Read: http://dev.mysql.com/doc/mysql/en/upgrade.html http://dev.mysql.com/doc/mysql/en/multiple-servers.html And search in archives about possible troubleshooting: http://lists.mysql.com/mysql/ mm <[EMAIL PROTECTED]> wrote: > > I have on my system, Fedora core 3, MySql 3.23.58 > Working with wikipedia database I get one error an one advise to upgrade > to Mysql 4.xx > Can I have old mySQL and the new one on my system? > It is necessary to recreate databases and reload the data? > What other kind of problem is suppose to find on my way during upgrade? > Thanks, > MT > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade mysql 3.23.58 to 4.1
Yes You can have both versions, infact this is the preferred way to upgrade, but the only thing is that have the new version install in /usr/local/mysql2/ or what ever you want and change the port that the newer daemon listens on instead of the default 3306, here's a good link from the doc's of mysql... http://dev.mysql.com/doc/mysql/en/upgrading-from-3-23.html Hope this helps, Kishore Jalleda On 6/24/05, mm <[EMAIL PROTECTED]> wrote: > > I have on my system, Fedora core 3, MySql 3.23.58 > Working with wikipedia database I get one error an one advise to upgrade > to Mysql 4.xx > Can I have old mySQL and the new one on my system? > It is necessary to recreate databases and reload the data? > What other kind of problem is suppose to find on my way during upgrade? > Thanks, > MT > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
upgrade mysql 3.23.58 to 4.1
I have on my system, Fedora core 3, MySql 3.23.58 Working with wikipedia database I get one error an one advise to upgrade to Mysql 4.xx Can I have old mySQL and the new one on my system? It is necessary to recreate databases and reload the data? What other kind of problem is suppose to find on my way during upgrade? Thanks, MT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
