Sounds like you have a script an generally you run "mysql < script.sql" and the database and tables get created. Make sure that the script creates your database and tables.
Nestor :-) -----Original Message----- From: lin ad [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 5:56 PM To: [EMAIL PROTECTED] Subject: new mysql database first, when i installed rh 7.3 i chose mysql and php and apache, i have tested apache and php independently and they work fine. next i can login into mysql with mysql -utest fine, basically, i have the mysql server running but never had a database. now i have a database but i don't know where to put it. now i have it in a temp dir. it is a file.sql . i am not sure but are databases 1 .sql file? i am not even sure if that is even a database file? i ftp'd all the .php files and put them in my /var/www/html there was also .sql file but i don't know what it is for or why it is there? that is the one that i opened and is default.sql, and i do not know what to do with that, when i open http://127.0.0.1 i get an error "unable to connect to database server" in /var/lib/mysql/mysql there are .myi and .myd and .frm files, i created none of this, i also did a mysqladmin create "newdb" then mysql>use newdb then put my file.sql file in that directory, when i do a mysql>status the "newdb" is current database, but i still get unable to connect to database, i just am not getting it, if the .sql file isn't the database then what is, the default.sql file inside says MySQL dump 8.21 but the file.sql when opened up says #database backup for shop.com #database: shop_ #database server: localhost so i mysqladmin create shop_ put the file.sql in /var/lib/mysql/shop_ then mysql>use shop_ mysql>status current database: shop_ still i get an error "unable to connect to server" any suggestions? __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
