Database in phpMyAdmin

[Encrier]

Hello,

How can I find my excisting database with phpMyAdmin.
Now it is located in the Xampp/htdocs

Thank you for you assistance.
Paul

[Wiedmann]

Now it is located in the Xampp/htdocs

A database can ot be located in this directory. So, what have you done?

[Encrier]

Thank you for your reply

I copied the database to this directory as I thoughd it was good that way.
But I realise it is no good.
In which directory do I have to put it??

Best regards,
Pau

[Wiedmann]

copied the database to this directory

Really a database or a sql dump?

[Encrier]

I copied the file from the server at OSCommerce.

The file has the extension .sql

I am very new to this, can you explain the difference between a "dump" and a real database?

[Wiedmann]

I copied the file from the server at OSCommerce.

You made this file with OSCommerce? Then there should be something in the manual for OSCommerce what to do with this file...

The file has the extension .sql

Then I guess it's a dump. You can import a dump into MySQL with e.g. phpMyAmdin or "mysql" in the shell.

[Encrier]

Can you please explain how I can import a dump into MySql with PHPMyAdmin?
Best regards,
Paul

[Izzy]

Can you please explain how I can import a dump into MySql with PHPMyAdmin?
Best regards,
Paul

Paul, open phpMyAdmin then in the drop box in the left frame select the database you want to import the dump to.

You will be presented with a new center frame with your database and at the top of the center frame you will see a menu row.

Select IMPORT

Now browse to the dump.sql file on your PC (dump.sql is only an example file name, yours may have a different name).

Select the Character set which will be evident near the top of the dump.sql file but you can leave it on the default setting for this exercise as you can change it later if required by re-importing the dump.sql file with a different character set if things go wrong.
The Character set may look something like this in your dump.exe file:
DEFAULT CHARSET=latin1
You can open the dump.sql file in any text editor of your choice to peruse its content.

Partial import ticked with a zero (default)

Format of import file is SQL

Click on the GO bottom right hand side.

Your done.

Now you should see your database populated with the data from the dump.sql file.

Obviously you have to have created your database first or there will be no place to create the tables and data etc. from the dump.sql file .

Good luck

[Encrier]

You are early this morning............

Thank you for your help, I will try it later today and report it here.

Thanks again and have a nice (long) day.
Paul

[Izzy]

It's 2:45 in the afternoon here but thanks for the greets any way.

[Encrier]

I noticed that you are in Australia, I am in France. That makes the difference.

[Encrier]

Thank you for your help, I succeeded.
best regards,
Paul