Thread: How to import table.sql to mysql?

hi trying install program: rosinfo:
- create mysql database rosinfo
- create table hosts, locks. use file docs/rosinfo.sql

, need create table hosts, locks, using file rosinfo.sql. have file, dont know it. help?

first make sure have mysql installed or whatever sql server using.

second type
mysql -u root -p

should mysql prompt there type this

create database rosinfo;

don't forget ;

exit mysql this

exit;

need import table type in

mysql -u root -p -d rosinfo < rosinfo.sql

lastly suggest getting phpmyadmin, make things easier.

Forum The Ubuntu Forum Community Ubuntu Specialised Support Ubuntu Servers, Cloud and Juju Server Platforms [ubuntu] How to import table.sql to mysql?

Ubuntu