MySql table upload problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • ree
    #1

    MySql table upload problem

    I have a tables for a database that I have entried data in to. I have used
    the table on my local comp. and used apache & mySql to test it out.


    Now I need to upload the table to the site. But not sure how to do it. I
    don't want to enter the details all again.

    Can someone point me to a link that explains how to upload these tables.

    Also the the webhost is using Cpanel.

    Ta

    Tags: None
    • Senator Jay Billington Bulworth
      #2
      Re: MySql table upload problem

      In article <Xns94568F751B4 03reehotmailcoo m@211.29.133.50 >,
      ree <ree@hotmail.co om> wrote:
      [color=blue]
      > I have a tables for a database that I have entried data in to. I have used
      > the table on my local comp. and used apache & mySql to test it out.
      >
      >
      > Now I need to upload the table to the site. But not sure how to do it. I
      > don't want to enter the details all again.
      >
      > Can someone point me to a link that explains how to upload these tables.
      >
      > Also the the webhost is using Cpanel.[/color]

      I believe CPanel lets you import MySQL dump files. You want to do a
      mysqldump to file, upload the dumpfile to your server, then import it to
      your database. man mysqldump, or check mysql.com for documentation on
      mysqldump.

      If your webhost lets you use mysql from the command line, here is a
      general example, assuming your database is named 'foo':

      //On your local server
      mysqldump -u user -p foo > dumpfile.sql
      [enter password]

      //On the remote server
      [create a database named 'foo']
      [upload dumpfile.sql]
      mysql -u user -p foo < dumpfile.sql
      [enter password]

      You'll need the first part to generate the dumpfile whether you use
      CPanel or not.

      hth

      --
      Bulworth : funha@fung.arg | My email address is ROT13 encoded, decode to mail
      --------------------------|--------------------------------------------------
      <http://www.phplabs.com/> | PHP scripts and thousands of webmaster resources!

        Comment

        • ree
          #3
          Re: MySql table upload problem

          Senator Jay Billington Bulworth <funha@fung.arg > wrote in
          news:funha-2A339C.05491419 122003@news-server-fe-01.columbus.rr. com:

          [color=blue]
          > [upload dumpfile.sql]
          > mysql -u user -p foo < dumpfile.sql
          > [enter password]
          >
          > You'll need the first part to generate the dumpfile whether you use
          > CPanel or not.
          >
          > hth
          >[/color]



          I cant find .sql files on my computer, just only these files in the mySQL
          "data" directory files for the tables with the extensions of *.MYD, *.MYI,
          *.FRM

            Comment

            • Capt. Beefheart
              #4
              Re: MySql table upload problem

              Whichever direcory you are in when you type

              mysql -u username -p password < dumfile.sql

              will be the directory you save dumpfile.sql. It's probably handy if you
              are in your home directory because you have to be able to save the file.
              That is, you have to have permission to write to the current directory.
              The files you described are the MySQL system files. You will/should not
              be able to save files to that directory.

              ree wrote:[color=blue]
              > Senator Jay Billington Bulworth <funha@fung.arg > wrote in
              > news:funha-2A339C.05491419 122003@news-server-fe-01.columbus.rr. com:
              >
              >
              >[color=green]
              >>[upload dumpfile.sql]
              >>mysql -u user -p foo < dumpfile.sql
              >>[enter password]
              >>
              >>You'll need the first part to generate the dumpfile whether you use
              >>CPanel or not.
              >>
              >>hth
              >>[/color]
              >
              >
              >
              >
              > I cant find .sql files on my computer, just only these files in the mySQL
              > "data" directory files for the tables with the extensions of *.MYD, *.MYI,
              > *.FRM[/color]

                Comment

                • Tim Van Wassenhove
                  #5
                  Re: MySql table upload problem

                  On 2003-12-21, ree <ree@hotmail.co om> wrote:[color=blue]
                  > Senator Jay Billington Bulworth <funha@fung.arg > wrote in
                  > news:funha-2A339C.05491419 122003@news-server-fe-01.columbus.rr. com:
                  >
                  >[color=green]
                  >> [upload dumpfile.sql][/color][/color]
                  [color=blue]
                  > I cant find .sql files on my computer, just only these files in the mySQL
                  > "data" directory files for the tables with the extensions of *.MYD, *.MYI,
                  > *.FRM[/color]

                  have a look at the mysqldump program...

                  --
                  verum ipsum factum

                    Comment

                    • ree
                      #6
                      Re: MySql table upload problem

                      "Capt. Beefheart" <Captain.Beefhe art@crystalfall s.com> wrote in
                      news:vXfFb.1$LK 6.0@news-binary.blueyond er.co.uk:

                      [color=blue][color=green]
                      >>
                      >>
                      >> I cant find .sql files on my computer, just only these files in the
                      >> mySQL "data" directory files for the tables with the extensions of
                      >> *.MYD, *.MYI, *.FRM[/color]
                      >[/color]



                      thanks u guys got it working

                        Comment

                        Previous template Next
                        Working...