Exporting my sql file, but cannot upload it back to server..
Heres the problem, I uploaded my files to the my server fine using phpMyAdmin. Then I exported the file using phpMyAdmin and saved it. Now what I've noticed is it's formatted differently. What I uploaded does not look the same as the sql file I exported. Look at example 1 below, it is the original file I uploaded using phpMyAdmin. Then Look at example 2, it is the file after phpMyAdmin exported it. You notice that all the # have been replaced now with --. This is my problem and the reason the sql file will not reload when I try to upload example 2 the exported file of example 1. If I go through and replace all the -- with # then it uploads fine. How do I get the file to export in the proper format, or how do I get phpMyAdin to upload the -- type format it exported to me. I cannot be the only person having this problem, yet I cannot find the solution anywhere for it, thanks for the help.
# phpMyAdmin SQL Dump
# version 2.5.7
# Host: localhost
# Generation Time: Jan 25, 2005 at 03:59 PM
# Server version: 4.0.18
# PHP Version: 4.3.8
# Database : `nuke`