We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
My database has more than 1000 tables, but I can only export part of it.
> select count(*) as totalnumberoftables from information_schema.tables where table_schema = 'dbname'; +---------------------+ | totalnumberoftables | +---------------------+ | 1015 | +---------------------+ 1 row in set (0.00 sec)
select all tables and export dbname.sql using adminerevo
dbname.sql
$ cat dbname.sql | grep 'CREATE TABLE' | wc -l 992
Version Ubuntu 24.04, AdminerEvo 4.8.4, MySQL version: 8.0.36-2ubuntu3 through PHP extension MySQLi
Ubuntu 24.04
AdminerEvo 4.8.4
MySQL version: 8.0.36-2ubuntu3 through PHP extension MySQLi
The text was updated successfully, but these errors were encountered:
This is a limitation of the php settings and your server hosting configuration..
issues must be close is there is no propert huge configuration for huge data in such server..
Sorry, something went wrong.
This is a limitation of the php settings and your server hosting configuration.. issues must be close is there is no propert huge configuration for huge data in such server..
I change max_input_vars setting of php.ini according to this link and it works now. Thank you.
max_input_vars
php.ini
No branches or pull requests
My database has more than 1000 tables, but I can only export part of it.
select all tables and export
dbname.sql
using adminerevoVersion
Ubuntu 24.04
,AdminerEvo 4.8.4
,MySQL version: 8.0.36-2ubuntu3 through PHP extension MySQLi
The text was updated successfully, but these errors were encountered: