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.

Need help dumping SQL

Discussion in 'Databases' started by Kremechoco, Feb 5, 2012.

0
  1. #1
    Alright, so I'm moving servers and my old server does not offer SSH/Telnet Access. I've checked their knowledgebase and everything. Says I can't.
    Is it possible to dump the SQL another way so I can transfer it?
     
    Kremechoco, Feb 5, 2012 IP
  2. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #2
    MySQL? You could upload phpMyAdmin and use it to dump a backup. Other database?
     
    Rukbat, Feb 25, 2012 IP
  3. gudzik

    gudzik Member

    Messages:
    44
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    43
    #3
    I do a base copy by a command file.

    @echo off
c:\webserver\mysql\bin\mysqldump.exe --all-databases -uroot -proot > full_dump.sql

arj m full_dump full_dump.sql
    Code (markup):
     
    gudzik, Mar 2, 2012 IP
  4. Serious Workers

    Serious Workers Well-Known Member

    Messages:
    2,785
    Likes Received:
    65
    Best Answers:
    2
    Trophy Points:
    195
    #4
    If the DB is bigger then 50MB then you won't be able to do it from PhpMyAdmin so better go for this tool - http://www.mysqldumper.net/
     
    Serious Workers, Mar 2, 2012 IP
  5. pindot

    pindot Active Member

    Messages:
    248
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    73
    #5
    if you have an access on the Cpanel, just configure to let your IP address to connect to your database. The use HeidiSQL to dump your data.
     
    pindot, Mar 19, 2012 IP
  6. yumyum8187

    yumyum8187 Peon

    Messages:
    11
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    This wouldn't work if he doesn't have ssh or shell access.
     
    yumyum8187, Mar 20, 2012 IP
  7. hehegame

    hehegame Peon

    Messages:
    54
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    The first: mysqldump -u YourDB -p YourPassword > YourDB.sql
    After, you will enter your password DB.
    Hope can help you
     
    hehegame, Mar 26, 2012 IP