Topic: How do I upload a mysql database

[Tib]

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

[Tib]

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

Persistence pays off  

Regards,

Tib

[byte]

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.

[trolljanz]

Shell version


This is how I usually do

# mysql

# \.  /dirToFile/mydump.sql