1 emmarie May 18, 2010 22:12
3 emmarie May 19, 2010 01:15
1. Check
2. Check
3. Error message.
What does this mean? I used all the default settings to ex- and import. Should I have changed something?
SQL query:
--
-- Database: `emmaried_bvlt1`
--
-- --------------------------------------------------------
--
-- Table structure for table `evo_antispam`
--
CREATE TABLE IF NOT EXISTS `evo_antispam` (
`aspm_ID` BIGINT( 11 ) NOT NULL AUTO_INCREMENT ,
`aspm_string` VARCHAR( 80 ) NOT NULL DEFAULT '',
`aspm_source` ENUM( 'local', 'reported', 'central' ) NOT NULL DEFAULT 'reported',
PRIMARY KEY ( `aspm_ID` ) ,
UNIQUE KEY `aspm_string` ( `aspm_string` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =19;
MySQL said:
#1046 - No database selected
4 markjl Jun 01, 2010 01:44
The export in PHPMyadmin works fine but the import gives the following error
Erreur
requête SQL:
--
-- Base de données: 'ipcas_b2e1'
--
--
-- Contenu de la table 'evo_antispam'
--
INSERT INTO evo_antispam( aspm_ID, aspm_string, aspm_source )
VALUES ( 1, 'penis-enlargement', 'reported' ) , ( 2, 'online-casino', 'reported' ) , ( 3, 'order-viagra', 'reported' ) , ( 4, 'order-phentermine', 'reported' ) , ( 5, 'order-xenical', 'reported' ) , ( 6, 'order-prophecia', 'reported' ) , ( 7, 'sexy-lingerie', 'reported' ) , ( 8, '-porn-', 'reported' ) , ( 9, '-adult-', 'reported' ) , ( 10, '-tits-', 'reported' ) , ( 11, 'buy-phentermine', 'reported' ) , ( 12, 'order-cheap-pills', 'reported' ) , ( 13, 'buy-xenadrine', 'reported' ) , ( 14, 'xxx', 'reported' ) , ( 15, 'paris-hilton', 'reported' ) , ( 16, 'parishilton', 'reported' ) , ( 17, 'camgirls', 'reported' ) , ( 18, 'adult-models', 'reported' ) ;
MySQL a répondu:Documentation
#1062 - Duplicate entry '1' for key 1
5 sam2kb Jun 01, 2010 05:02
Make sure you import in the empty database, there should be no b2evo tables in it.
1.Download all of your ftp b2 folders&files.
2.Export your database-sql- via phpmyadmin
3. Upload and import your backed up files.
as easy as that