07-26-2006, 10:22 AM
You are just about to hear the most basic question.
I have created a small table in mysql but I do not know what the name of my database is.
How can I find out?
I can ssh to my database server and can also log in and enter the control panel.
I have created a tabel but I do not know how to find out the name of the databse so I can import data to it.
Please please help.
Please let me know what information you need.
if you enter the control panel (which one?), can't you then see the mysql-db's then?
07-26-2006, 11:45 AM
I think thats part of my problem.
All I can see is Control Pael writing at top, below ADMIN,ACCOUNTS DOAMINS LOGS HELP LOGOUT.
Then I have table list, with the name of my table.
On the left options are list tables,create table, export data and run sql.
try running this sql-statement:
07-26-2006, 01:25 PM
If you have CPANEL then you should also see a link to phpmyadmin which you would use to interface with mysql to create tables, queries etc.
07-26-2006, 01:36 PM
simple command , did the job.
I still don't know what sort of control panel I have, but at least I solved the database part of it.
Now I have to figure out how to input the large database file into it, as there is a 5MB size limit on importing it thorugh the control panel. But thats another story.
07-26-2006, 01:38 PM
When you say control panel do you mean you are using CPANEL or phpmyadmin or something entirely different?
07-26-2006, 01:42 PM
The top part just says Control Panel, printed as part of a logo.
No sign of a phpmyadmin.
I would be grateful if you would tell me what command I should use with ssh to load a .sql file back to database though. As it is too big to use it through teh control panel (under RunSQL)
mysql --database=jackamsdatabase --user=jackam --password=password < sqldump.sql
07-26-2006, 03:37 PM
I get this error message when I try it.
I also got this error when i tried afew times before...
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql --database=xxxx --user=xxxx --password=xxx < xxxx' at line 1
07-26-2006, 03:43 PM
When I tried again, I just got a mysql prompt at the next line.(mysql>) with no error messages.
Does that mean it is exporting?
just check the results...
select the db with "USE dbname;"
then a "SHOW tables;" or a "SELECT * FROM tablename;"
(enter commands (without double quotes) at the mysql>-prompt and replace italics by db or table names)
07-26-2006, 05:12 PM
Have chekced, its no good.
I even split the large 6MB file in two, But still no use.
I get the rror message "query was empty" when tried to load it through teh control panel.