How to you inport that db.schema

[Anonymous]

im using mysqlfront and im use that you guys have done this and i haven't found anything to help me do this im using windows xp and apache and mysql any help with this matter would be good

Thanks

[Mikael Starck]

go to the cmd promt.
type cd mysql
cd bin

mysqladmin create databasae poc

mysql -u root -p (database) < path to dir

example:

mysql -u root -p poc < c:/tmp/pocdatabase.sql
password:XXXXXX

done

hope it helps

[Mikael Starck]

sorry this is the correct syntax....

mysqladmin create Poc

mysql -u root -p password poc < /your/path/to/phpopenchat/db.schema

hope it helps

[Gemmy]

I have the same problem, but a different system.  My webhost has php & mysql installed, and the database name is created.  I also have access to my webspace via ftp.

Any ideas how I can import this file?

Thanks
Gemmy

[Kris Leech]

If doing it over the web use phpMyAdmin.
It lets you choose a sql file (db.schema) to create the tables in a db.
Installing phpMyAdmin is really easy and helpful for all db tasks over the web

Kris.

[eddycurrents]

I was able to get SSH access to my ISP's server. I couldn't find mysqladmin admin on the server, but I did find mysql. So I couldn't create a new database called "poc", but I could add to my existing one (the one the ISP created for me).

I used something like:

/usr/local/psa/mysql/bin/mysql --user=user --pass=password mydatabasename < db.schema

In my case, my database name was the same as my user name. I was in the php chat directory so I didn't need a pathname to db.schema.