Results 1 to 6 of 6

Thread: [MySQL] Export a DB From PHPMyAdmin to /var/lib/mysql

  1. #1
    Member registered user
    Join Date
    Jul 2003
    Location
    France / Finland
    Posts
    61

    [MySQL] Export a DB From PHPMyAdmin to /var/lib/mysql

    Hello,
    I would like to know if it is possible to export my actual DB from my website that I manage with PHPmyadmin to copy it into my /var/lib/mysql

    I did not find how to do that...
    I manage to create an empty DB but that's it

    Thxs
    Ludo

  2. #2
    Junior Member
    Join Date
    Aug 2003
    Posts
    2
    Hope this helps,

    What I did was setup a script that actually deletes the httpd.conf and php.ini files, and then creates links to my database folders and config files that are stored on my pen memory device. This way, I don't lose any of the data during a reboot.

    #!/bin/sh

    chmod 777 -R /etc/apache
    chmod 777 -R /var/www
    chmod 777 -R /etc/php4/apache

    rm /etc/apache/httpd.conf

    rm /etc/php4/apache/php.ini

    ln -s /mnt/sda1/httpd.conf /etc/apache/httpd.conf
    ln -s /mnt/sda1/htdocs /var/www/htdocs
    ln -s /mnt/sda1/php.ini /etc/php4/apache/php.ini

    apachectl start

    chmod 777 -R /var/lib/mysql

    ln -s /mnt/sda1/citydata /var/lib/mysql/citydata

    /usr/bin/mysqld_safe &

    echo "Done with setup"


    MadWebGuru
    Bruce

  3. #3
    Member registered user
    Join Date
    Jul 2003
    Location
    France / Finland
    Posts
    61
    Hmm that's not exactly what I meant.
    Perhaps I should try to post it on the HDD install. Because I've knoppix installed on my HDD.

    thxs anyway

  4. #4
    Junior Member
    Join Date
    Aug 2003
    Posts
    2
    I just copied the actual files over from a different box.

    Using the script I provided, you could create a empty folder that is linked into the /var/lib/mysql and then use phpMyAdmin to import a exported dump. The dump should contain the sql needed to define the tables for your database.

    MadWebGuru
    Bruce

  5. #5
    Member registered user
    Join Date
    Jul 2003
    Location
    Delft, the Netherlands
    Posts
    76

    Re: [MySQL] Export a DB From PHPMyAdmin to /var/lib/mysql

    Quote Originally Posted by Coume
    Hello,
    I would like to know if it is possible to export my actual DB from my website that I manage with PHPmyadmin to copy it into my /var/lib/mysql
    According to www.phpmyadmin.net you can make a backup. Now the problem can be how to ftp those backups over, but that depends on the setup on your remote host.

    [Edit]
    According to their faq you can transfer the backup directly to your machine
    [/Edit]

    - - Edwin

  6. #6
    Member registered user
    Join Date
    Jul 2003
    Location
    France / Finland
    Posts
    61
    hi,

    Ok I'll try to have a deeper look into myphpadmin and see if my host allow to export the data too...

    thxs
    Ludo

Similar Threads

  1. MySQL
    By mzee in forum Knoppix DVD
    Replies: 17
    Last Post: 10-12-2005, 08:48 AM
  2. Mysql with databases on HDD
    By sbb in forum General Support
    Replies: 3
    Last Post: 12-28-2004, 05:14 AM
  3. apache and mysql
    By dr_rude in forum General Support
    Replies: 2
    Last Post: 10-11-2004, 02:37 AM
  4. [mysql] how do I use it???
    By Coume in forum Hdd Install / Debian / Apt
    Replies: 3
    Last Post: 08-04-2003, 07:00 AM
  5. Get me going with MySQL
    By Terry@nz in forum General Support
    Replies: 3
    Last Post: 06-09-2003, 10:01 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
  •  


Dell Poweredge R640 Server | 2x Xeon Gold 6132 | 512GB | H730P | 8x HDD Trays picture

Dell Poweredge R640 Server | 2x Xeon Gold 6132 | 512GB | H730P | 8x HDD Trays

$2549.00



Dell Poweredge R640 Server | 2x Silver 4114 20 Cores | 64GB | 8x HDD Trays picture

Dell Poweredge R640 Server | 2x Silver 4114 20 Cores | 64GB | 8x HDD Trays

$1614.99



Dell Poweredge R640 Server | 2x Silver 4114 20 Cores | 16GB | 2x HDD Trays picture

Dell Poweredge R640 Server | 2x Silver 4114 20 Cores | 16GB | 2x HDD Trays

$1349.99



Dell Poweredge R640 Server | 2x Gold 6140 | 512GB | H730P | 4x 2.4TB 10KRPM HDDs picture

Dell Poweredge R640 Server | 2x Gold 6140 | 512GB | H730P | 4x 2.4TB 10KRPM HDDs

$3995.00



Dell PowerEdge R730XD 28 Core Server 2X Xeon E5-2680 V4 H730 128GB RAM No HDD picture

Dell PowerEdge R730XD 28 Core Server 2X Xeon E5-2680 V4 H730 128GB RAM No HDD

$389.99



HP Proliant DL360 Gen9 28 Core SFF Server 2X E5-2680 V4 16GB RAM P440ar No HDD picture

HP Proliant DL360 Gen9 28 Core SFF Server 2X E5-2680 V4 16GB RAM P440ar No HDD

$196.95



Dell PowerEdge R720XD Xeon E5-2680 V2 2.8GHz 20 Cores 256GB RAM 12x4TB picture

Dell PowerEdge R720XD Xeon E5-2680 V2 2.8GHz 20 Cores 256GB RAM 12x4TB

$510.00



Dell PowerEdge R720 Server - 2x8c CPU,256Gb RAM, 128Gb SSD/3x900Gb SAS, Proxmox picture

Dell PowerEdge R720 Server - 2x8c CPU,256Gb RAM, 128Gb SSD/3x900Gb SAS, Proxmox

$340.00



DELL PowerEdge R730 Server 2x E5-2680v4 2.4GHz =28 Cores 32GB H730 4xRJ45 picture

DELL PowerEdge R730 Server 2x E5-2680v4 2.4GHz =28 Cores 32GB H730 4xRJ45

$284.00



HP ProLiant DL380 Gen9 16SFF 2x E5-2680v4 2.4GHz =28 Cores 64GB P840 4xRJ45 picture

HP ProLiant DL380 Gen9 16SFF 2x E5-2680v4 2.4GHz =28 Cores 64GB P840 4xRJ45

$353.00