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.



Example 1:
=================

# phpMyAdmin SQL Dump
# version 2.5.7
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jan 25, 2005 at 03:59 PM
# Server version: 4.0.18
# PHP Version: 4.3.8
#
# Database : `nuke`
#

# --------------------------------------------------------

#
# Table structure for table `nuke_authors`
#

CREATE TABLE `nuke_authors` (
`aid` varchar(25) NOT NULL default '',
`name` varchar(50) default NULL,
`url` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`pwd` varchar(40) default NULL,
`counter` int(11) NOT NULL default '0',
`radminsuper` tinyint(1) NOT NULL default '1',
`admlanguage` varchar(30) NOT NULL default '',
PRIMARY KEY (`aid`),
KEY `aid` (`aid`)
) TYPE=MyISAM;

#
# Dumping data for table `nuke_authors`
#

----------------END EXAMPLE------------------------------------


Example 2:
===============================


-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 26, 2005 at 02:24 PM
-- Server version: 4.0.18
-- PHP Version: 4.3.8
--
-- Database: `nuke`
--

-- --------------------------------------------------------

--
-- Table structure for table `nuke_authors`
--

CREATE TABLE `nuke_authors` (
`aid` varchar(25) NOT NULL default '',
`name` varchar(50) default NULL,
`url` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`pwd` varchar(40) default NULL,
`counter` int(11) NOT NULL default '0',
`radminsuper` tinyint(1) NOT NULL default '1',
`admlanguage` varchar(30) NOT NULL default '',
PRIMARY KEY (`aid`),
KEY `aid` (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nuke_authors`
--

---------------------end------------------------




thanks for the help