Skip to content

Instantly share code, notes, and snippets.

@ledoyen
Last active April 5, 2018 18:49
Show Gist options
  • Save ledoyen/3a7c5619c870f9b332c2194160d725c0 to your computer and use it in GitHub Desktop.
Save ledoyen/3a7c5619c870f9b332c2194160d725c0 to your computer and use it in GitHub Desktop.
Importer les données dans Alexandria Book Library

Importer les données dans Alexandria Book Library

1. (La première fois ou après un changement de schéma) Créer le schéma de la base locale

Installer une base MYSQL 4.1 Lancer le script create_schema.sql
C'est à dire, dans HeidiSQL :
Dans une onglet "requête":
Coller le contenu du fichier create_schema.sql
Cliquer sur la flèche bleu (executer ou F9)

2. Exporter le dump depuis l'écran d'administration

Sur l'écran administrator/index.php?option=com_abook&view=importexport
Cliquer sur le bouton export avec le type Mysql backup.
Echapper le noms des tables en les entouranbt du caractère backtick `.
Par exemple : #__abauthor doit devenir `#__abauthor`.
Utiliser la macro dans Notepadd++ nommée escape_bibliotheque_dump

3. Importer les données dans la base locale

Dans HeidiSQL :
Supprimer les anciennes données en lancant le script suivant:

-- Supression données
truncate table `#__abauthor`;
truncate table `#__abbook`;
truncate table `#__abbookauth`;
truncate table `#__abcategories`;
truncate table `#__abeditor`;
truncate table `#__ablibrary`;
truncate table `#__ablocations`;

Ensuite charger le fichier SQL du dump avec le nom des tables modifiés. Executer le fichier en cliquant sur la flèche bleu (F9).

DROP TABLE IF EXISTS `#__abauthor`;
DROP TABLE IF EXISTS `#__abbook`;
DROP TABLE IF EXISTS `#__abbookauth`;
DROP TABLE IF EXISTS `#__abcategories`;
DROP TABLE IF EXISTS `#__abeditor`;
DROP TABLE IF EXISTS `#__ablibrary`;
DROP TABLE IF EXISTS `#__ablocations`;
CREATE TABLE `#__abauthor` (
`id` TINYTEXT NOT NULL,
`lastname` TEXT NOT NULL,
`name` TEXT NOT NULL,
`alias` TEXT NOT NULL,
`image` TEXT NOT NULL,
`description` TEXT NOT NULL,
`checked_out` TEXT NOT NULL,
`checked_out_time` TEXT NOT NULL,
`metakey` TEXT NOT NULL,
`metadesc` TEXT NOT NULL,
`state` TEXT NOT NULL,
`language` TEXT NOT NULL,
INDEX `PK` (`id`(10))
)
;
CREATE TABLE `#__abbook` (
`id` TINYTEXT NOT NULL,
`asset_id` TEXT NOT NULL,
`title` TEXT NOT NULL,
`subtitle` TEXT NOT NULL,
`alias` TEXT NOT NULL,
`ideditor` TEXT NOT NULL,
`price` TEXT NOT NULL,
`pag` TEXT NOT NULL,
`pag_index` TEXT NOT NULL,
`user_id` TEXT NOT NULL,
`created_by_alias` TEXT NOT NULL,
`description` LONGTEXT NOT NULL,
`image` TEXT NOT NULL,
`docsfolder` TEXT NOT NULL,
`file` TEXT NOT NULL,
`year` TEXT NOT NULL,
`idlocation` TEXT NOT NULL,
`idlibrary` TEXT NOT NULL,
`vote` TEXT NOT NULL,
`numvote` TEXT NOT NULL,
`hits` TEXT NOT NULL,
`state` TEXT NOT NULL,
`catid` TEXT NOT NULL,
`qty` TEXT NOT NULL,
`isbn` TEXT NOT NULL,
`issn` TEXT NOT NULL,
`doi` TEXT NOT NULL,
`numpublication` TEXT NOT NULL,
`approved` TEXT NOT NULL,
`userid` TEXT NOT NULL,
`url` TEXT NOT NULL,
`url_label` TEXT NOT NULL,
`dateinsert` TEXT NOT NULL,
`catalogo` TEXT NOT NULL,
`checked_out` TEXT NOT NULL,
`checked_out_time` TEXT NOT NULL,
`access` TEXT NOT NULL,
`metakey` TEXT NOT NULL,
`metadesc` TEXT NOT NULL,
`metadata` TEXT NOT NULL,
`language` TEXT NOT NULL,
`ordering` TEXT NOT NULL,
`params` TEXT NOT NULL,
`note` TEXT NOT NULL,
`editedby` TEXT NOT NULL,
INDEX `PK` (`id`(10))
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `#__abbookauth` (
`id` TINYTEXT NULL,
`ordering` TINYTEXT NULL,
`idbook` TINYTEXT NULL,
`idauth` TINYTEXT NULL
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `#__abcategories` (
`id` TINYTEXT NULL,
`asset_id` TINYTEXT NULL,
`parent_id` TINYTEXT NULL,
`lft` TEXT NULL,
`rgt` TEXT NULL,
`level` TEXT NULL,
`path` TEXT NULL,
`extension` TEXT NULL,
`title` TEXT NULL,
`alias` TEXT NULL,
`note` TEXT NULL,
`description` TEXT NULL,
`published` TEXT NULL,
`checked_out` TEXT NULL,
`checked_out_time` TEXT NULL,
`access` TEXT NULL,
`params` TEXT NULL,
`metadesc` TEXT NULL,
`metakey` TEXT NULL,
`metadata` TEXT NULL,
`created_user_id` TEXT NULL,
`created_time` TEXT NULL,
`modified_user_id` TEXT NULL,
`modified_time` TEXT NULL,
`hits` TEXT NULL,
`language` TEXT NULL,
`version` TEXT NULL,
INDEX `PK` (`id`(10))
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `#__abeditor` (
`id` TINYTEXT NOT NULL,
`name` TEXT NULL,
`alias` TEXT NULL,
`description` TEXT NULL,
`checked_out` TEXT NULL,
`checked_out_time` TEXT NULL,
`metakey` TEXT NULL,
`metadesc` TEXT NULL,
`state` TEXT NULL,
`language` TEXT NULL
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `#__ablibrary` (
`id` TINYTEXT NOT NULL,
`name` TEXT NULL,
`alias` TEXT NULL,
`description` TEXT NULL,
`email` TEXT NULL,
`checked_out` TEXT NULL,
`checked_out_time` TEXT NULL,
`state` TEXT NULL,
`language` TEXT NULL,
INDEX `PK` (`id`(10))
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
CREATE TABLE `#__ablocations` (
`id` TINYTEXT NOT NULL,
`name` TEXT NULL,
`alias` TEXT NULL,
`checked_out` TEXT NULL,
`checked_out_time` TEXT NULL,
`state` TEXT NULL,
`language` TEXT NULL,
INDEX `PK` (`id`(10))
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment