Re: importing data base error and general question about zen
Here are some notes that may help. These are the steps I take.
- I create the database in PHPMyAdmin.
- Use zc_install to create the tables.
- Import the unzipped old database file using the command line or if you use Laragon on Windows instead of Xamp try HeidiSQL. ( I gave up importing with PHPMyadmin a long time ago as it is slow and problematic.) See below for the export settings required.
- Run zc_install again to upgrade the database structure.
I export the databases using PHPMyadmin with the following settings:
Custom:
select all tables
save output to a file
filename template @DATABASE@_%Y-%m-%d_%T
file character set utf-8
compression gzipped
display comments
enclose export in a transaction
add drop table
auto increment value
add create procedure
add create trigger
enclose table and column names with backquotes
syntax to use = both
dump binary columns in hexadecimal
dump timestamp columns in UTC
These settings allow me to overwrite the tables on import each time.
OldNGrey
ZC158a PHP 8.2.15
MySQL 10.6.16-MariaDB
Bookmarks