Anyone got any ideas why a MySQLDump would give stuff like this out;
--
-- Host: localhost Database: aceins_linkssql
---------------------------------------------------------
-- Server version 3.23.54
--
-- Table structure for table 'PayPal_Info'
--
CREATE TABLE PayPal_Info (
SetID int(11) NOT NULL auto_increment,
ItemName text NOT NULL,
ItemPrice float NOT NULL default '0',
ItemSales int(4) NOT NULL default '0',
CancelURL text NOT NULL,
Message text NOT NULL,
UNIQUE KEY SetID (SetID)
) TYPE=MyISAM;
Note that the ##'s are replaced with --'s
I'm gonna do a temp fix, and just add a file open/read, and change the --'s into hashes. Anyone got an idea as to why it would do this though?
The query I am using is;
mysqldump -uusername -ppassword -hlocalhost database > /path/to/file/for/saving.sql
Cheers for any ideas:)
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Code:
-- MySQL dump 8.22 --
-- Host: localhost Database: aceins_linkssql
---------------------------------------------------------
-- Server version 3.23.54
--
-- Table structure for table 'PayPal_Info'
--
CREATE TABLE PayPal_Info (
SetID int(11) NOT NULL auto_increment,
ItemName text NOT NULL,
ItemPrice float NOT NULL default '0',
ItemSales int(4) NOT NULL default '0',
CancelURL text NOT NULL,
Message text NOT NULL,
UNIQUE KEY SetID (SetID)
) TYPE=MyISAM;
Note that the ##'s are replaced with --'s
I'm gonna do a temp fix, and just add a file open/read, and change the --'s into hashes. Anyone got an idea as to why it would do this though?
The query I am using is;
mysqldump -uusername -ppassword -hlocalhost database > /path/to/file/for/saving.sql
Cheers for any ideas:)
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!