Johnny Mysql

[paladox2014]

Hi it seems johnny MySQL is having a problem because I went onto my website which uses mediawiki and said there was a problem with the database so I deleted it and recreated it but it would not let me recreate the tables. please help.

 

user = pal2015

website = wiksaur.tk

server = johnny

[paladox2014]

And it is still showing databases I deleted. please help it wont let me use my backup because it is corrupt so I am doing a new install but it wont it keeps stoping when it is installing and says this error

 

 

Install

 

 

A database query error has occurred. This may indicate a bug in the software.

• Query:
  CREATE TABLE `user` ( user_id int unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT, user_name varchar(255) binary NOT NULL default '', user_real_name varchar(255) binary NOT NULL default '', user_password tinyblob NOT NULL, user_newpassword tinyblob NOT NULL, user_newpass_time binary(14), user_email tinytext NOT NULL, user_touched binary(14) NOT NULL default '', user_token binary(32) NOT NULL default '', user_email_authenticated binary(14), user_email_token binary(32), user_email_token_expires binary(14), user_registration binary(14), user_editcount int, user_password_expires varbinary(14) DEFAULT NULL ) ENGINE=InnoDB, DEFAULT CHARSET=binary
  
• Function: DatabaseBase::sourceFile( /home/pal2015/public_html/maintenance/tables.sql )
  
• Error: 1146 Table 'pal2015_wiki6.user' doesn't exist (localhost)
  

Backtrace:

#0 /home/pal2015/public_html/includes/db/Database.php(1184): DatabaseBase-&--#62;reportQueryError('Table 'pal2015_...', 1146, 'CREATE TABLE `u...', 'DatabaseBase::s...', false)

#1 /home/pal2015/public_html/includes/db/Database.php(3948): DatabaseBase-&--#62;query('CREATE TABLE `u...', 'DatabaseBase::s...')

#2 /home/pal2015/public_html/includes/db/Database.php(3862): DatabaseBase-&--#62;sourceStream(Resource id #97, false, false, 'DatabaseBase::s...', false)

#3 /home/pal2015/public_html/includes/installer/DatabaseInstaller.php(196): DatabaseBase-&--#62;sourceFile('/home/pal2015/p...')

#4 /home/pal2015/public_html/includes/installer/DatabaseInstaller.php(218): DatabaseInstaller-&--#62;stepApplySourceFile('getSchemaPath', 'install', true)

#5 [internal function]: DatabaseInstaller-&--#62;createTables(Object(MysqlInstaller))

#6 /home/pal2015/public_html/includes/installer/Installer.php(1584): call_user_func(Array, Object(MysqlInstaller))

#7 /home/pal2015/public_html/includes/installer/WebInstallerPage.php(1418): Installer-&--#62;performInstallation(Array, Array)

#8 /home/pal2015/public_html/includes/installer/WebInstaller.php(280): WebInstallerInstall-&--#62;execute()

#9 /home/pal2015/public_html/mw-config/index.php(79): WebInstaller-&--#62;execute(Array)

#10 /home/pal2015/public_html/mw-config/index.php(38): wfInstallerMain()

#11 {main}

 

Notice: Uncommitted DB writes (transaction from DatabaseInstaller::stepApplySourceFile). in /home/pal2015/public_html/includes/db/Database.php on line 4238

• 
  

 

please help me.

 

and were it says .user doesent exist is because it stoped working and because i tryed installing it twice because first time it said something like mysql carnt connect through socket. please reset mysql or restart it please.