Database & phpMyAdmin
Solved
buns38
Posted messages
23
Status
Member
-
lets -
lets -
Hello
I exported my database to import it on another computer, in phpMyAdmin to edit it, and I'm getting this message:
"The specified XML file was malformed or incomplete. Please correct it and try again."
I tried to import it as .SQL and I'm getting an error message.
What should I do, where is the error?
I exported my database to import it on another computer, in phpMyAdmin to edit it, and I'm getting this message:
"The specified XML file was malformed or incomplete. Please correct it and try again."
I tried to import it as .SQL and I'm getting an error message.
What should I do, where is the error?
8 answers
With .SQL, I have this message:
Error
SQL Query:
-- Database: 'xxx_bdd'
--
-- --------------------------------------------------------
--
-- Structure of the table 'u6frt_aicontactsafe_config'
--
CREATE TABLE IF NOT EXISTS 'u6frt_aicontactsafe_config' (
'id' INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
'config_key' VARCHAR( 50 ) NOT NULL DEFAULT '',
'config_value' TEXT NOT NULL ,
PRIMARY KEY ( 'id' )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =31;
MySQL responded: Documentation
#1046 - No database selected
Error
SQL Query:
-- Database: 'xxx_bdd'
--
-- --------------------------------------------------------
--
-- Structure of the table 'u6frt_aicontactsafe_config'
--
CREATE TABLE IF NOT EXISTS 'u6frt_aicontactsafe_config' (
'id' INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
'config_key' VARCHAR( 50 ) NOT NULL DEFAULT '',
'config_value' TEXT NOT NULL ,
PRIMARY KEY ( 'id' )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =31;
MySQL responded: Documentation
#1046 - No database selected
I created a start of a site with Joomla, then I exported the database that I can't import on my second computer.