Database in phpMyAdmin

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Database in phpMyAdmin

Postby Encrier » 25. July 2006 17:53

Hello,

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

Thank you for you assistance.
Paul
"There is no way to happiness, happiness is the way...."
Encrier
 
Posts: 23
Joined: 08. June 2006 05:43

Postby Wiedmann » 25. July 2006 18:09

Now it is located in the Xampp/htdocs

A database can ot be located in this directory. So, what have you done?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Encrier » 25. July 2006 19:08

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
"There is no way to happiness, happiness is the way...."
Encrier
 
Posts: 23
Joined: 08. June 2006 05:43

Postby Wiedmann » 25. July 2006 19:18

copied the database to this directory

Really a database or a sql dump?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Encrier » 25. July 2006 19:29

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?
"There is no way to happiness, happiness is the way...."
Encrier
 
Posts: 23
Joined: 08. June 2006 05:43

Postby Wiedmann » 25. July 2006 19:45

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.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby Encrier » 26. July 2006 05:12

Can you please explain how I can import a dump into MySql with PHPMyAdmin?
Best regards,
Paul
"There is no way to happiness, happiness is the way...."
Encrier
 
Posts: 23
Joined: 08. June 2006 05:43

Postby Izzy » 26. July 2006 05:38

Encrier wrote: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 :)
Last edited by Izzy on 26. July 2006 05:53, edited 2 times in total.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby Encrier » 26. July 2006 05:42

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
"There is no way to happiness, happiness is the way...."
Encrier
 
Posts: 23
Joined: 08. June 2006 05:43

Postby Izzy » 26. July 2006 05:44

It's 2:45 in the afternoon here :D but thanks for the greets any way.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby Encrier » 26. July 2006 16:05

I noticed that you are in Australia, I am in France. That makes the difference.
"There is no way to happiness, happiness is the way...."
Encrier
 
Posts: 23
Joined: 08. June 2006 05:43

Postby Encrier » 28. July 2006 16:04

Thank you for your help, I succeeded.
best regards,
Paul
"There is no way to happiness, happiness is the way...."
Encrier
 
Posts: 23
Joined: 08. June 2006 05:43


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 56 guests