Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 13 of 13
  1. #1
    New Coder
    Join Date
    Jul 2006
    Location
    UK
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    What is the name ofmysql database? newbie!!

    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.
    Thanks alot.
    jack

  • #2
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    if you enter the control panel (which one?), can't you then see the mysql-db's then?
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

  • #3
    New Coder
    Join Date
    Jul 2006
    Location
    UK
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi raf

    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.
    Any ideas?
    thanks
    jack

  • #4
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    try running this sql-statement:
    SHOW databases
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

  • #5
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    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.

  • #6
    New Coder
    Join Date
    Jul 2006
    Location
    UK
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi raf.
    simple command , did the job.
    many thanks
    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.
    thanks quelphdad.

  • #7
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    When you say control panel do you mean you are using CPANEL or phpmyadmin or something entirely different?

  • #8
    New Coder
    Join Date
    Jul 2006
    Location
    UK
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi
    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)
    thanks
    jack

  • #9
    Senior Coder
    Join Date
    Sep 2005
    Posts
    1,791
    Thanks
    5
    Thanked 36 Times in 35 Posts
    mysql --database=jackamsdatabase --user=jackam --password=password < sqldump.sql

  • #10
    New Coder
    Join Date
    Jul 2006
    Location
    UK
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi

    I get this error message when I try it.
    I also got this error when i tried afew times before...
    Any ideas?
    thanks


    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

  • #11
    New Coder
    Join Date
    Jul 2006
    Location
    UK
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi
    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?
    thanks
    jack

  • #12
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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)
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

  • #13
    New Coder
    Join Date
    Jul 2006
    Location
    UK
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Raf

    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.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •