mysql nerds

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Chris
    Too lazy to set a custom title
    • May 2003
    • 27880

    #1

    mysql nerds

    if your at the mysql console what is the command to import a .sql file locally like if the .sql file was on the same computer
    [email protected]
  • StuartD
    Sofa King Band
    • Jul 2002
    • 29903

    #2
    source file.sql
    This is me on facebook
    This is me on twitter

    Comment

    • teksonline
      So Fucking Banned
      • Jan 2005
      • 2904

      #3
      ctrl-v for paste hehe

      we do mysql -u<user> -p <dbname> <blah.sql

      Comment

      • b3ck
        Registered User
        • Jan 2005
        • 4

        #4
        hey that question was asked by me thru chris, just wanted to let you all know that it worked and it was a lot faster than doing it thru navicat, I was able to load a 184 mb database in less than 5 mins with the mysql console, rather than 12+ hours thru navicat it was still going on well after the mysql console was finished... Thanks again all =)

        -b3ck

        Comment

        • gooddomains
          Too lazy to set a custom title
          • Jul 2003
          • 10127

          #5
          sql *****

          Comment

          • b3ck
            Registered User
            • Jan 2005
            • 4

            #6
            sql what???

            Comment

            Working...