Topic: importing tables into mysql

[Kim Knudsen]

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

[Charlie Brady]

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

[Kim Knudsen]

Can anyone help me findig these updates?

nimmer

[BobbyW]

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

-BobbyW

[Kim Knudsen]

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

nimmer

[Pete]

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

[Dean Mumby]

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

[Kim Knudsen]

Hi,

What do I need the glibc files for?

nimmer

[Dean Mumby]

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

.

[Kim Knudsen]

Thnx,

I got it working now - I think!

nimmer