1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Convert mysql files to .sql files

Discussion in 'MySQL' started by countrydj, Nov 26, 2020.

  1. #1
    My databases are all mysql. They are stored as databse directory, and database.frm, database.MYD, database.MYI.
    I need to convert tese to .sql in order to upload to another provider.
    Can anybody tell me how to do it.
    Thankyou, John C
    SEMrush
     
    countrydj, Nov 26, 2020 IP
    SEMrush
  2. mmerlinn

    mmerlinn Prominent Member

    Messages:
    3,195
    Likes Received:
    816
    Best Answers:
    7
    Trophy Points:
    320
    #2
    If these are standard DBF files, why can't you just change the extension?
     
    mmerlinn, Nov 26, 2020 IP
  3. countrydj

    countrydj Active Member

    Messages:
    41
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    91
    #3
    I have been told by the new hoster, NAMECHEAP, that I need to upload my database as .sql.
    Since there are 3 file extensions, how can I change them all to .sql?
     
    countrydj, Nov 30, 2020 IP
  4. countrydj

    countrydj Active Member

    Messages:
    41
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    91
    #4
     
    countrydj, Nov 30, 2020 IP
  5. countrydj

    countrydj Active Member

    Messages:
    41
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    91
    #5
    Another posibility, if it is possible, is to host the website on one server and host the mysql files on another server (my own).
    Has anybody any idea if this is possible, and if so, how to do it.
    Thanks,
    John C
     
    countrydj, Nov 30, 2020 IP
  6. myreseller home

    myreseller home Greenhorn

    Messages:
    24
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    13
    #6
    To “convert it to .sql” you need the data in a running MySQL server. You’d then run the mysqldump tool to query the live server and write the data to a .sql file.
     
    myreseller home, Apr 26, 2022 IP
  7. TimLewis

    TimLewis Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #7
    I have been using MySQL for several years, and I have found different useful tools. So I can share the one of them that I use frequently - mysql ado.net provider. There is a free trial, so you can check out how it works.
     
    TimLewis, May 19, 2022 at 8:32 AM IP