Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Kim Knudsen on July 05, 2003, 12:38:21 AM

Title: importing tables into mysql
Post by: Kim Knudsen on July 05, 2003, 12:38:21 AM

I'm moving from a Windows 2000 server to SME 5.6 and I have to move all the websites hosted on the w2k-server to the SME server. My problem is that I don't know how to move the mysql databases from w2k to SME.

I'm using MySQL-front to administer my databases on w2k and I thought that I just could use this to connect to mysql on SME, but no matter what I do I can't login to the SME mysql.

Plz. help

nimmer

Title: Re: importing tables into mysql
Post by: Charlie Brady on July 05, 2003, 12:54:18 AM

Kim Knudsen wrote:
> ... I
> thought that I just could use this to connect to mysql on
> SME, but no matter what I do I can't login to the SME mysql.

By default mysql is only used for webmail, and can only be connected to locally (i.e. from the server itself). Search here thoroughly for required updates and configuration changes to allow other connections.

Charlie

Title: Re: importing tables into mysql
Post by: Kim Knudsen on July 05, 2003, 01:28:34 AM

Can anyone help me findig these updates?

nimmer

Title: Re: importing tables into mysql
Post by: BobbyW on July 05, 2003, 08:09:15 AM

Download and install phpmyadmin from http://www.phpmyadmin.net/ into its own ibay.  Its the best tool you can use for managing MySQL.

-BobbyW

Title: Re: importing tables into mysql
Post by: Kim Knudsen on July 05, 2003, 11:27:36 AM

I have installed phpmyadmin, but I can't figure out how to import tables/databases from here.

nimmer

Title: Re: importing tables into mysql
Post by: Pete on July 05, 2003, 01:46:58 PM

Kim,

If you are having trouble finding the glibc rpms try these URLs.

http://www.math.unl.edu/linux/redhat/apt/7.3/RPMS.edu/glibc-2.2.5-43.i386.rpm
http://www.math.unl.edu/linux/redhat/apt/7.3/RPMS.edu/glibc-common-2.2.5-43.i386.rpm

Pete

Title: Re: importing tables into mysql
Post by: Dean Mumby on July 05, 2003, 02:44:05 PM

Have you tried mysqldump

create the same database on your sme server and give a user the appropriate permision

 

mysqldump db | mysql -h 192.168.3.x db -u dbuser -pdbpass

Regards
Dean

Title: Re: importing tables into mysql
Post by: Kim Knudsen on July 06, 2003, 12:11:20 PM

Hi,

What do I need the glibc files for?

nimmer

Title: Re: importing tables into mysql
Post by: Dean Mumby on July 06, 2003, 02:14:02 PM

You need the updated Glibc to be able to make remote conections to your mysql database

.

Title: Re: importing tables into mysql
Post by: Kim Knudsen on July 06, 2003, 03:19:59 PM

Thnx,

I got it working now - I think!

nimmer