Question No tables in database
- tezywezy
- Topic Author
- Offline
- Junior Member
- Tony
Less
More
8 years 1 month ago #1
by tezywezy
webtrees 1.7.16
huckle-parker.info
PHP 7.3
Mysql 5.6.20
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
"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.
- fisharebest
- Offline
- Administrator
8 years 1 month ago #2
by fisharebest
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
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?
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
- Tony
8 years 1 month ago #3
by tezywezy
webtrees 1.7.16
huckle-parker.info
PHP 7.3
Mysql 5.6.20
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
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
- Tony
7 years 11 months ago - 7 years 11 months ago #4
by tezywezy
webtrees 1.7.16
huckle-parker.info
PHP 7.3
Mysql 5.6.20
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
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.
- fisharebest
- Offline
- Administrator
7 years 11 months ago #5
by fisharebest
Greg Roach - greg@subaqua.co.uk - @fisharebest@phpc.social - fisharebest.webtrees.net
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?
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
- Tony
7 years 11 months ago #6
by tezywezy
webtrees 1.7.16
huckle-parker.info
PHP 7.3
Mysql 5.6.20
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)
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
- Tony
7 years 11 months ago - 7 years 11 months ago #7
by tezywezy
webtrees 1.7.16
huckle-parker.info
PHP 7.3
Mysql 5.6.20
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
no idea what ive done to cause this
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.