upload db to MySQL
Posted on 2012-03-13
I have trouble to upload a file to MySQL. At first what I did was to create a database named <videos>, then create a table named <myvideos>. I added 4 fields (video_id, video_name, ftp_folder, html_file). These folders were added directly in the phpMyAdmin.
When I tried to export the database to the computer, it worked without any problem.
But when I tried to import the database (the file was updated with 4 rows), MySQL returned a 1064 error.
I don't know what I did wrong. But the file that I wanted to upload had a .SQL extension. I also tried with a .CSV extension, but same problem.
Any help would be appreciated.