have problem with my database ?

[chennairam]

Hi People please Tel me

In my database i can see some Row Newly

Can any body tell what is that Rows

https://vborg.vbsupport.ru/external/2009/09/70.jpg


In red Box i Marked

[snakes1100]

Sounds like your db user dont have the correct permissions on the db and can't delete tables correctly.

Unless your generating 1000's of them, i wouldnt worry about it.

Check your user for the db has full delete permissions on the db.

[chennairam]

really Dont understand

Can tell me Extractly please

[snakes1100]

Log into your cpanel and check the user that you assigned to your database and make sure he has delete permissions for said database.

[chennairam]

Log into your cpanel and check the user that you assigned to your database and make sure he has delete permissions for said database.

only one user i assigned

how can i delete that now

[snakes1100]

Just edit the user thru the db admin interface in cpanel and make sure it has delete permissions assigned to it, there is no need to delete the current user.

[chennairam]

Just edit the user thru the db admin interface in cpanel and make sure it has delete permissions assigned to it, there is no need to delete the current user.

Really i dont understand.... i made backup of my database database.sql.gz

after i extract it will 158mb

after i imported but i dont current style and current users i lost more than 8000+ users

in phpmyadmin i can see more all users like 53.737 users


In forum i cant see

--------------- Added 1252124117 at 1252124117 ---------------

Really Strange Problem

When i trying to import my shared hosting getting this error

Server Replied: ERROR 1062 (23000)
at line 534375:
Duplicate entry
'???????' for key 2
ERROR 1062 (23000)
at line 535899:
Duplicate entry '??'
for key 2
ERROR 1062 (23000)
at line 537412:
Duplicate entry
'???????' for key 2
ERROR 1062 (23000)
at line 538960:
Duplicate entry
'????' for key 2
ERROR 1062 (23000)
at line 540498:
Duplicate entry
'???????????' for
key 2
ERROR 1062 (23000)
at line 542029:
Duplicate entry '??'
for key 2
ERROR 1062 (23000)
at line 543536:
Duplicate entry
'?????' for key 2
ERROR 1062 (23000)
at line 544992:
Duplicate entry
'?????' for key 2
ERROR 1062 (23000)
at line 546486:
Duplicate entry
'????' for key 2

[snakes1100]

The user im speaking of is the username set in your config.php file that you created/setup in cpanel, your server responds on port 2082, so i know you have cpanel.

The error you posted about now, you can run a repair on your db tables with phpmyadmin and try to repair it, if not you will need to speak to your host.

Why did you import a back up anyways?

[chennairam]

Sir can you tell me How to Repair ... i didnt set Anything in config.php

Really My old server have some problems
so backup and import

If Import Without any error Some times

But All user And setting Okey

Lot of Thread & posts Missing

here The Screenshots

https://vborg.vbsupport.ru/external/2009/09/64.jpg

https://vborg.vbsupport.ru/external/2009/09/65.jpg

Please Help me Lot of thread missing

[chennairam]

Please help me anyone please still problem exist

[Lynne]

If you don't understand how to make sure your mysql user has the correct permissions to your database, you may want to put in a support ticket at vb.com so they can check that for you.

[Medtech]

why not just drop those tables in phpmyadmin? looks to me like they serve no purpose..

[chennairam]

why not just drop those tables in phpmyadmin? looks to me like they serve no purpose..

I backup database From phpmyadmin


After import in New server

Lot of Thread missing

Users all Okey


Can you Tell me How to Drop the tables

[blind-eddie]

If you are not comfortable working within your database, I would recommend getting assistance from someone so you don't damage your database be dropping (deleting) the wrong tables.

It is rather easy to do, but wouldn't recommend it if your somewhat new working on databases...just my opinion.

[Medtech]

post cleared by me, could have been mistaken as spam

[Marco van Herwaarden]

PHPMyAdmin is not the most reliable way to make a backup.

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php

[blind-eddie]

His issue has nothing to do with permissions, they are set to all permissions.

I looked at Ram's database and found the following empty tables, all empty.
He says that this happened when he moved to another server & is moving again.

cpsession (Table is empty)

http://outerzone.us/forum/imagehosting/14aa5ecee79342.bmp

================================================== ===============


20 tables named aaggregate_temp (All Empty)

http://outerzone.us/forum/imagehosting/14aa5ee4a7be6f.bmp


================================================== ===============

44 tables named taggregate_temp (All Empty)

http://outerzone.us/forum/imagehosting/14aa5ef38a71e1.bmp

================================================== ===============

He has lost a bunch of info from the move & can't get it back, no backups from what I am understanding. He did say he had missing attachments & threads.

What issues will he have with his site without these tables? Can they just be removed?

[Marco van Herwaarden]

Those empty tables shold not cause any problems.

[chennairam]

actually i Try to Dedicated server to Shared Hostig Temporary

But while Get backup is 250Mb from dedicated server ... later i Import in Sharedhosting that database .... every thing Okey , users ,

But mail problem is Most of thead's not open

So i think imy database had problem

Unwanted table Create automatically

So blind-eddie Trying to Help me