Help transfering 90MB MySQL Database

Discussion in 'MySQL' started by midwestbonsai, Dec 18, 2007.

0
  1. #1
    Folks,

    I need help and don't really know where to begin.

    I need to transfer web hosts, on my current host I have a 90MB MySQL database (for a forum). I need to transfer it to the new hosts MySQL database.

    I only have phpMyAdmin access to the server.

    I ope I have given you enough info.
     
    midwestbonsai, Dec 18, 2007 IP
  2. nafishasan60

    nafishasan60 Well-Known Member

    Messages:
    198
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    110
    #2
    PM me. On msn I can help you how you can transfer you MySQL Database.
     
    nafishasan60, Dec 18, 2007 IP
  3. Tanzil Ahmed

    Tanzil Ahmed Well-Known Member

    Messages:
    357
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    110
    #3
    Do you have shell access or cpanel then the transfer is very much easy
     
    Tanzil Ahmed, Dec 18, 2007 IP
  4. jobbank

    jobbank Well-Known Member

    Messages:
    1,095
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    128
    #4
    jobbank, Dec 18, 2007 IP
  5. doctorjones

    doctorjones Active Member

    Messages:
    418
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    58
    #5
    thanks jobbank for the link!
     
    doctorjones, Dec 28, 2007 IP
  6. deltrumweb

    deltrumweb Banned

    Messages:
    502
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Just upload a mysql dump tool and you can restore the db using your browser ;)
     
    deltrumweb, Dec 28, 2007 IP
  7. midwestbonsai

    midwestbonsai Well-Known Member

    Messages:
    402
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    105
    #7
    Hey thanks for all of the replies. But I have run into a snag.
    The current database is MSSQL and I want to put it on to a MySQL database.
    Is this even possible?
     
    midwestbonsai, Dec 28, 2007 IP
  8. midwestbonsai

    midwestbonsai Well-Known Member

    Messages:
    402
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    105
    #8
    No Shell access, control panel access and PHPMyAdmin
     
    midwestbonsai, Dec 28, 2007 IP
  9. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #9
    You can export the MSSQL data into CSV format and then import that
    into mysql. You may need to split the csv files into small size chunks
    using some file splitter program before importing using phpmyadmin.
     
    Kuldeep1952, Dec 29, 2007 IP
  10. Mazaonline

    Mazaonline Peon

    Messages:
    1,006
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #10
    using ssh access if u have, then it's so easy to move and transfer Your data,if u need any help pm me ..
     
    Mazaonline, Dec 29, 2007 IP
  11. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #11
    hi

    I can do this fr you $25

    50% advance
    Pm me if interested

    Regards

    Alex
     
    kmap, Dec 30, 2007 IP
  12. deltrumweb

    deltrumweb Banned

    Messages:
    502
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #12
    This is easy to do...you do not need an sql professional to do this.
     
    deltrumweb, Dec 30, 2007 IP
  13. midwestbonsai

    midwestbonsai Well-Known Member

    Messages:
    402
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    105
    #13
    This is just getting more and more complicated.

    The current host of the website and the database will not give me access to the database server. Instead they have created a .BAK file (that I cannot open) that I downloaded via FTP.

    Hence the reason for dumping them in the first place.

    Is it possible to load this file into a MySQL database?
     
    midwestbonsai, Jan 9, 2008 IP
  14. jigolo

    jigolo Peon

    Messages:
    312
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #14
    Upload your dump to your server into the /home directory then use the following command to restore it

    mysql -u USERNAME -p mysql_database_name < /home/database_dumpname.sql

    the next thing that will popup is the password prompt.
     
    jigolo, Jan 10, 2008 IP
  15. midwestbonsai

    midwestbonsai Well-Known Member

    Messages:
    402
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    105
    #15
    Were woud I type that? In PHPMyAdmin?
     
    midwestbonsai, Jan 10, 2008 IP
  16. midwestbonsai

    midwestbonsai Well-Known Member

    Messages:
    402
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    105
    #16
    Well, here is where i am so far.

    I have installed SQL Server 2005, and SQL Server Management Studio Express on my machine.

    I have restored the .BAK file to the MSSQL database.

    Now I need to figure out how to get it from there to a usable mysql file with the insert statements and such.
     
    midwestbonsai, Jan 11, 2008 IP