Author Topic: export database error in phpmyadmin  (Read 1342 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
export database error in phpmyadmin
« on: February 18, 2021, 05:04:39 AM »
hai

unable to export database from phpmyadmin. getting the following error when tried to export data

Notice in ./export.php#252
 Undefined index: output_format

Backtrace

Notice in ./export.php#266
 Undefined index: compression

Backtrace

Notice in ./export.php#387
 Undefined variable: filename_template

Backtrace

Offline
*
Re: export database error in phpmyadmin
« Reply #1 on: April 03, 2021, 11:33:40 AM »
Hello

I got the same errors

Also I found difficulties when creating the user for new databases and grant privileges.

What should be checked and corrected?

Thank you.

Offline
*****
Re: export database error in phpmyadmin
« Reply #2 on: April 03, 2021, 01:07:24 PM »
from root user you're trying ?

Offline
*
Re: export database error in phpmyadmin
« Reply #3 on: April 04, 2021, 04:29:50 AM »
Hi
Yes, also from root user
Also, when calling the export page give me this message "warning, a form on this page has more than 1000 fileds,,, On submission some of the fileds might be omitted...." but on that page there is nothing like that
« Last Edit: April 04, 2021, 04:35:03 AM by David »

Offline
*****
Re: export database error in phpmyadmin
« Reply #4 on: April 04, 2021, 04:35:59 AM »
try via command line to export a db :

Code: [Select]
mkdir -p /home/mysqldump
cd /home/mysqldump
mysqldump > db-name.sql

if you see error in mysql command line then its your DB issue and your dev need to fix it

Offline
*
Re: export database error in phpmyadmin
« Reply #5 on: April 04, 2021, 05:04:23 AM »
Hi
I did it, it works, dumped the DB and gave no errors

Offline
*
Re: export database error in phpmyadmin
« Reply #6 on: April 10, 2021, 06:48:34 PM »
Hello

I checked as suggested if the dump can happen via command line, it does, however I want to fix this phpmyadmin problem
When in phpMyadmin I do click export for a db or a table to start with gives me a warning, it tells that has to show more than 1000 records, that some will be omitted, and that this is due to max_input_var settings.

I checked php.ini and saw that max_input-Var was commented, I uncommented it and settled to 14000, a high number, this did not change the problem, I have done it in all the php.ini files I found

Then clicking on export I get these errors as already stated above in this thread, and does not let export from within phpMyadmin:

Notice in ./export.php#252
Undefined index: output_format

Backtrace

Notice in ./export.php#266
Undefined index: compression

Backtrace

Notice in ./export.php#387
Undefined variable: filename_template

Backtrace

What should I check/do to fix this?

Thank you