Jump to content

Search the Community

Showing results for tags 'mysql data error'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • General Discussion
    • Website Management and Coding
    • Technology and the Internet
    • Philosophy, Politics, and Science
    • Art and Entertainment
    • Other Discussion
  • HelioHost
    • Questions
    • Customer Service
    • How You Can Help
  • HelioNet
    • News
    • Contact HelioNet

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

Found 1 result

  1. I created a mySQL database in cPanel called tstewart_tsunami, as well as a user tstewart_root, which I then gave access to the database and gave it full privileges. Additionally I used the '%' wildcard to allow remote access to any host. I log into the database using the command line: C:\Program Files\MySQL\MySQL Server 5.6\bin>mysql -h johnny.heliohost.org -u tstewart_root -p tstewart_tsunami and created a table in tstewart_tsunami called sourceEvents, and I want to load the data from a tab delimited file into this table. I tried to do this using this statement: mysql> LOAD DATA INFILE 'C:\Documents and Settings\tstewart\WebSites\ExamplesSite\tsevent.txt' INTO TABLE sourceEvents; but I get the error: I have not really done this before so perhaps I am missing something, but I thought that by adding the user to the database and allowing remote connections this should work. I should note that after connecting to my database in Visual Studio I could see the new table, and when I check the DB in cPanel I can see that the table was created. So apparently I can remotely create tables but for some reason I cannot load data into them.
×
×
  • Create New...