![]() However, it requires a webserver to run even a locally developed webpage. If you have a huge production database you may need to turn to some of the alternatives suggested in other posts here.PHP is the most popular and widely-used server-side scripting language for web development. Your mileage will vary but I can see no intrinsic value in exporting either the cache tables nor watchdog from a production system on a server to your local Wamp or Xamp or Wampserver or whatever. of course a reminder that this is on a copy of the database you've made, not the one you use in production. I've suggested emptying tables starting with "cache_" and the watchdog table. ![]() Or you can just go through the list and work on the tables individually, emptying those you want. Then down at the bottom of the list of tables there will be a "With Selected" box and you pick empty. You select the tables you want to work on with the check box on the left. Where "acl" is the first table in the list. In PHPmyadmin when you look at the "structure" for a given database you'll get a list of tables. I deleted and recreated the database but I get this errorĪ34333839333b7d7d7d, -1, '1598206184.292', 1, 'config:core.extension views_data', '743')ĮRROR 2013 (HY000) at line 13886: Lost connection to MySQL server during query ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = 'Stores details about batches (processes that run inÔǪ'ĮRROR 1050 (42S01) at line 31: Table 'batch' already exists `batch` longblob COMMENT 'A serialized array containing the processing data for the batch.' `timestamp` int (11) NOT NULL COMMENT 'A Unix timestamp indicating when this batch was submitted for processing. `token` varchar (64) CHARACTER SET ascii NOT NULL COMMENT 'A string token generated against the current user''s session id and the batch id, used to ensure that only the user who submitted the batch can effectively access it.', `bid` int (10) UNSIGNED NOT NULL COMMENT 'Primary Key: Unique batch ID.', *! 40101 SET = COLLATION_CONNECTION * / *! 40101 SET = CHARACTER_SET_RESULTS * / *! 40101 SET = CHARACTER_SET_CLIENT * / ![]() ![]() This error comes back to me which is strange as I deleted everything I followed your advice and tried to manually import the sql file.īefore importing I deleted all the tables of the dataBase Mysqli::query(): Error reading result set's header \libraries\classes\Dbi\DbiMysqli.php#199: mysqli->query( Mysqli::query(): MySQL server has gone away Sono stati trovati 1 errori durante l'analisi.Įspressione mancante. I tried to import both the last backup and the previous ones but nothing to do. Oops, with phpMyAdmin select the database and import. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |