Results 1 to 2 of 2

Thread: [HOWTO] Backup MySQL databases without shell access

  1. #1
    Join Date
    Jun 2003
    Location
    The Netherlands
    Posts
    415

    [HOWTO] Backup MySQL databases without shell access

    I see a lot of questions regarding the backing up of your mysql databases without having ssh access. I had the same questions, especially if your changing hosts or trying to make a local backup. You might run into the fact that you don't have shell access, which makes exporting and importing a lot more easy by dumping the mysql database. So how do you do it then?

    There are 2 ways of doing this, either using phpmyadmin which is very usefull and comes readily installed in DA. The problem with phpmyadmin is that it only works for smaller databases. With large databases you might get a timeout either downloading or uploading the *.sql file.

    The other way is to use a frontend to connect to your database and either download it or transfer it directly to the other database. The frontend I'm using for windows which does this marvelously well is "MySQL-Front" (yeah I know, too obvious), which can be downloaded here.

    You enter your mysql login information and connect. You do the same for the other mysql server and then you choose im-/export - Export Tables.... You then choose which tables (probably all) and the output. If you want to backup locally you might export to file, if you want to change from host you might want to choose the third option.

    * Note: For this to work you have to add yourself to the allowed hosts list. For more information about this check out the following topic.

    http://www.directadmin.com/forum/sho...=&threadid=477
    Last edited by S2S-Robert; 09-04-2003 at 04:56 PM.

  2. #2
    Join Date
    Sep 2003
    Location
    UK
    Posts
    3
    Just wanted to say thanks, this may just save us an awful lot of work and heartache

Similar Threads

  1. Shell Fork Bomb/Memory Hog Protection Howto
    By bipinkdas in forum Operating System (OS) Related Discussion
    Replies: 0
    Last Post: 08-24-2007, 12:36 AM
  2. HOWTO Delete r57 r99 shell files
    By hostcini in forum How-To Guides
    Replies: 4
    Last Post: 07-21-2007, 06:56 AM
  3. Backup locks PHP or MySQL access?
    By pluk in forum MySQL / PHP
    Replies: 0
    Last Post: 01-22-2007, 12:27 PM
  4. How to prevent DA from allowing shell access?
    By hendrix74 in forum General Technical Discussion & Troubleshooting
    Replies: 2
    Last Post: 04-14-2005, 09:35 AM
  5. Show who has shell access
    By jjma in forum Admin-Level Difficulties
    Replies: 2
    Last Post: 02-24-2005, 03:25 PM

Posting Permissions

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