Can't export database

[ciellauren]

I keep encountering missing parameter errors when I try to export my database for back up.

It points to missing parameter 2.8 which says

export.php: Missing parameter: what (FAQ 2.8)
export.php: Missing parameter: export_type (FAQ 2.8)

and FAQ 2.8 is

2.8 I get "Missing parameters" errors, what can I do?

Here are a few points to check:

• In config.inc.php, try to leave the $cfg['PmaAbsoluteUri'] directive empty. See also FAQ 4.7.
• Maybe you have a broken PHP installation or you need to upgrade your Zend Optimizer. See http://bugs.php.net/bug.php?id=31134.
• If you are using Hardened PHP with the ini directive varfilter.max_request_variables set to the default (200) or another low value, you could get this error if your table has a high number of columns. Adjust this setting accordingly. (Thanks to Klaus Dorninger for the hint).
• In the php.ini directive arg_separator.input, a value of ";" will cause this error. Replace it with "&;".
• If you are using Hardened-PHP, you might want to increase request limits.
• The directory specified in the php.ini directive session.save_path does not exist or is read-only.

$cfg['PmaAbsoluteUri'] stringSets here the complete URL (with full path) to your phpMyAdmin installation's directory. E.g. http://www.your_web.net/path_to_your_phpMyAdmin_directory/. Note also that the URL on some web servers are case–sensitive. Don’t forget the trailing slash at the end.

Starting with version 2.3.0, it is advisable to try leaving this blank. In most cases phpMyAdmin automatically detects the proper setting. Users of port forwarding will need to set PmaAbsoluteUri (more info). A good test is to browse a table, edit a row and save it. There should be an error message if phpMyAdmin is having trouble auto–detecting the correct value. If you get an error that this must be set or if the autodetect code fails to detect your path, please post a bug report on our bug tracker so we can improve the code.

Now, i didn't set that $cfg directive, nor am I using hardened php

Is it possible that my parked domain is causing this error? http://upd.edu.ph/~ced

If not, is there another way to back up the site?

 

[misson]

I keep encountering missing parameter errors when I try to export my database for back up.

What options are you picking? What databases, export format, export type, save as file (or not) &c? What happens if you try other options (specifically changing which databases you're exporting and which export type)?

Now, i didn't set that $cfg directive, nor am I using hardened php

It's not whether you did or are, it's how the server is set up. That said, I don't believe X10 uses hardened php and can't tell if that configuration directive is set. However, I can report that DB export works on Lotus with default options, so it's probably not a problem with either the config option or hardened PHP.

What happens when you try the FAQ's advice and edit a row, then save it? What if you create a new table, fill it with a little data and try to export it?

Is it possible that my parked domain is causing this error?

I don't see how. While I can't guarantee it's not, I'd say it's highly unlikely to be the cause.

If not, is there another way to back up the site?

You could always use your own export script, but there should be a way to get phpMyAdmin's export to work.

 

[ciellauren]

Hi Misson,

Thanks. So here's more:

What options are you picking? What databases, export format, export type, save as file (or not) &c? What happens if you try other options (specifically changing which databases you're exporting and which export type)?

database name: _drupal
options: default, also once i tried checking add DROP TABLE/VIEW (didn't work)
export format: SQL
export type: INSERT
save as file: checked, i also tried normal, zipped and gzipped

It's chopin and I checked the config directive it wasn't set. I tried with other databases, same error occurred. *sigh*

You could always use your own export script, but there should be a way to get phpMyAdmin's export to work.

I guess this is the only option left. :-(

 

[misson]

Did you try to edit a row as the doc for $cfg['PmaAbsoluteUri'] suggests? Did you try creating a new table with a few entries in an existing database, and exporting that? Have you ever been able to export a database? Also, try:

• exporting with as few options as possible, such as exporting only the structure or only the data
• create a new database with a new table, fill it with a few entries, export.
• use a different export type
• combinations of the above (including the first paragraph and previous post)

If all of the above fails, there's probably something the admins need to fix. Even if some of them succeed, an admin will probably need to fix something. You should try the above before escalating so the admins have enough information to track down the cause of the error.