Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

import/export

Archer282Archer282 Member Posts: 243
I would like to know how i can export my database to a .sql file, similar to the way phpMyAdmin does it, without using phpMyAdmin, and also how to import it, thanks..

Comments

  • mike8mike8 Member Posts: 4
    Hi,

    I suggest to try a popular MySQL GUI Like MySQL Turbo Manager or MySQL Manager.

    MySQL Turbo Manager
    http://www.mentattech.com/themes/mentat/mysqlmanager/index.html

    Regards,


    : I would like to know how i can export my database to a .sql file, similar to the way phpMyAdmin does it, without using phpMyAdmin, and also how to import it, thanks..
    :
  • daviestrachandaviestrachan Member Posts: 26
    : Hi,
    :
    : I suggest to try a popular MySQL GUI Like MySQL Turbo Manager or MySQL Manager.
    :
    : MySQL Turbo Manager
    : http://www.mentattech.com/themes/mentat/mysqlmanager/index.html
    :
    : Regards,
    :
    :
    : : I would like to know how i can export my database to a .sql file, similar to the way phpMyAdmin does it, without using phpMyAdmin, and also how to import it, thanks..
    : :
    :

    Hi
    Try
    $result = mysql_query("SELECT * INTO OUTFILE 'data.sql' FIELDS TERMINATED BY ',' FROM table");

    $result = mysql_query("LOAD DATA INFILE 'data.sql' INTO TABLE table FIELDS TERMINATED BY ','");
    Regards Davie


Sign In or Register to comment.