import export - Programmers Heaven

Howdy, Stranger!

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

Categories

import export

wajahatwajahat Posts: 24Member
how we import and export database and data in MySql

Comments

  • JonathanJonathan Posts: 2,914Member
    Hi,

    : how we import and export database and data in MySql
    I think you can do an INSERT INTO table FILE filename or something like that. Can't remember exactly...it'll be in the MySQL docs - just look it up. Export I guess just SELECT all the data and store it.

    If you want an automated tool to do all this I recommend phpMyAdmin.
    http://phpmyadmin.sourceforge.net/

    Hope this helps,

    Jonathan


    ###
    ('Is Perl Just Another Hack?' =~ /^w+ (w+) (w+) (w+)(er) (w+)?$/) and print "$2 $3$4 $1 $5$4";
    ###
    http://www.incrahost.com/ :: Great Hosting!
    ###

Sign In or Register to comment.