Web based family history software

Question No tables in database

  • tezywezy
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Tony
More
8 years 1 month ago #1 by tezywezy
No tables in database was created by tezywezy
When I attempt to backup my database from online server I get the error
"Error: No tables found in database `xxxxxxxx_xxx` "
how can there be no tables when site is running as normal

webtrees 1.7.16
huckle-parker.info
PHP 7.3
Mysql 5.6.20

Please Log in or Create an account to join the conversation.

More
8 years 1 month ago #2 by fisharebest
Replied by fisharebest on topic No tables in database
> "Error: No tables found in database `xxxxxxxx_xxx` "

This error might be more accurately phrased

"Error: No tables (for which you have access permission) found in database `xxxxxxxx_xxx` "

Perhaps you are doing your backup using a different MySQL user account to the one used in webtrees?

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • tezywezy
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Tony
More
8 years 1 month ago #3 by tezywezy
Replied by tezywezy on topic No tables in database
Thanks for the very quick reply
I will look into that one, but as far asI know I only created one user as I am the only one that has any access to server & website

webtrees 1.7.16
huckle-parker.info
PHP 7.3
Mysql 5.6.20

Please Log in or Create an account to join the conversation.

  • tezywezy
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Tony
More
7 years 11 months ago - 7 years 11 months ago #4 by tezywezy
Replied by tezywezy on topic No tables in database
Still stuck with this problem & not sure how to solve it,
my expertise is not that great so any specific help would be greatly appreciated

webtrees 1.7.16
huckle-parker.info
PHP 7.3
Mysql 5.6.20
Last edit: 7 years 11 months ago by tezywezy.

Please Log in or Create an account to join the conversation.

More
7 years 11 months ago #5 by fisharebest
Replied by fisharebest on topic No tables in database
> Still stuck with this problem

What problem? You imply that your backup software/process isn't working. What software/process?

Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net

Please Log in or Create an account to join the conversation.

  • tezywezy
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Tony
More
7 years 11 months ago #6 by tezywezy
Replied by tezywezy on topic No tables in database
have just removed "mysqldumper" module & program & will try again with "myphpadmin"
will get back shortly

database is named xxxxxmain2 but backup software only sees xxxxxmain1 (which is empty)

webtrees 1.7.16
huckle-parker.info
PHP 7.3
Mysql 5.6.20

Please Log in or Create an account to join the conversation.

  • tezywezy
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Tony
More
7 years 11 months ago - 7 years 11 months ago #7 by tezywezy
Replied by tezywezy on topic No tables in database
have backed up xxxxxmain2 (which seems to have the tables in) yet here is a pic of the databases
no idea what ive done to cause this

webtrees 1.7.16
huckle-parker.info
PHP 7.3
Mysql 5.6.20
Attachments:
Last edit: 7 years 11 months ago by tezywezy.

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum
}