Koozali.org: home of the SME Server

Contribs.org Forums => General Discussion => Topic started by: Tib on October 27, 2006, 04:59:41 AM

Title: How do I upload a mysql database
Post by: Tib on October 27, 2006, 04:59:41 AM

Hello,

I need help with mysql database uploads into SME.

What I have done is a mysqldump from a windows based program (Knowledge Tree) that uses mysql.

Now I would like to upload that database into SME7.0 .... what are the comands to upload my saved dump file.

I have done a few searches on the net but nothing seems to work.

Also phpmyadmin doesn't seem to have an import feature only export.

Regards,

Tib

Title: How do I upload a mysql database
Post by: Tib on October 27, 2006, 05:26:33 AM

It's ok ... I woked it out.

Persistence pays off  :D

Regards,

Tib

Title: Re: How do I upload a mysql database
Post by: byte on October 27, 2006, 11:35:53 AM

Quote from: "Tib"

Also phpmyadmin doesn't seem to have an import feature only export.

For others phpMyAdmin does have a import feature, you would have to create your database first then select your new database and choose the "SQL" tab along the top and where the box which says...

Location of the textfile:

Just upload your file.

Title: How do I upload a mysql database
Post by: trolljanz on October 27, 2006, 01:20:47 PM

Shell version


This is how I usually do

# mysql

# \.  /dirToFile/mydump.sql