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
IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
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
IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

