SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Nov 2006
    Posts
    60
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Transfer Databases?

    Hello,

    I want to transfer some databases from my machine to my web server. Do I just mysql dump and then upload them to the server database? If so, how do I upload them, which command?

    Thanks,

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    If you have a dump per table, you can run a LOAD DATA INFILE query for each, or run mysql from the command line with the full database SQL dump as input:

    Code:
    mysql -uusername -p --database dbname < input.sql


Bookmarks

Posting Permissions

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