Lost the `wp_options` table: what's the best way to restore the site?

Clash Royale CLAN TAG#URR8PPP

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty margin-bottom:0;

up vote
1
down vote

favorite

Due to some important hardware failure, the wp_options table of one of my WP sites became corrupted, but everything else is okay (WP files and other tables). Obviously the site does not work because of this, and I had no backups.

What would be the best way to repair this? How can I create a fresh wp_options table for my WP version?

database

share|improve this question

asked 3 hours ago

eepp

1062

New contributor

eepp is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

up vote
1
down vote

favorite

Due to some important hardware failure, the wp_options table of one of my WP sites became corrupted, but everything else is okay (WP files and other tables). Obviously the site does not work because of this, and I had no backups.

What would be the best way to repair this? How can I create a fresh wp_options table for my WP version?

database

share|improve this question

asked 3 hours ago

eepp

1062

New contributor

eepp is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

up vote
1
down vote

favorite

up vote
1
down vote

favorite

Due to some important hardware failure, the wp_options table of one of my WP sites became corrupted, but everything else is okay (WP files and other tables). Obviously the site does not work because of this, and I had no backups.

What would be the best way to repair this? How can I create a fresh wp_options table for my WP version?

database

share|improve this question

asked 3 hours ago

eepp

1062

New contributor

eepp is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

Due to some important hardware failure, the wp_options table of one of my WP sites became corrupted, but everything else is okay (WP files and other tables). Obviously the site does not work because of this, and I had no backups.

What would be the best way to repair this? How can I create a fresh wp_options table for my WP version?

database

database

share|improve this question

asked 3 hours ago

eepp

1062

New contributor

eepp is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked 3 hours ago

eepp

1062

New contributor

eepp is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

share|improve this question

asked 3 hours ago

eepp

1062

New contributor

eepp is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 3 hours ago

eepp

1062

asked 3 hours ago

eepp

1062

1062

New contributor

eepp is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

New contributor

eepp is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

eepp is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

add a comment | 

1 Answer
1

active

oldest

votes

up vote
2
down vote

Uh oh, that's an important table. You might have lost a bunch of options, but you can still repair the database. WordPress allows a repair mode, which you can repair the database.

Open the wp-config.php file using FTP, and add this line before the ABSPATH:

define( 'WP_ALLOW_REPAIR', true );

now head over to :

http://yourdomain.com/wp-admin/maint/repair.php

Follow the steps to repair your broken database.

share|improve this answer

answered 3 hours ago

Jack Johansson♦

11.1k71440

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "110"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

eepp is a new contributor. Be nice, and check out our Code of Conduct.

 

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fwordpress.stackexchange.com%2fquestions%2f314993%2flost-the-wp-options-table-whats-the-best-way-to-restore-the-site%23new-answer', 'question_page');

);

Post as a guest

Name Email

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

active

oldest

votes

active

oldest

votes

up vote
2
down vote

Uh oh, that's an important table. You might have lost a bunch of options, but you can still repair the database. WordPress allows a repair mode, which you can repair the database.

Open the wp-config.php file using FTP, and add this line before the ABSPATH:

define( 'WP_ALLOW_REPAIR', true );

now head over to :

http://yourdomain.com/wp-admin/maint/repair.php

Follow the steps to repair your broken database.

share|improve this answer

answered 3 hours ago

Jack Johansson♦

11.1k71440

add a comment | 

up vote
2
down vote

Uh oh, that's an important table. You might have lost a bunch of options, but you can still repair the database. WordPress allows a repair mode, which you can repair the database.

Open the wp-config.php file using FTP, and add this line before the ABSPATH:

define( 'WP_ALLOW_REPAIR', true );

now head over to :

http://yourdomain.com/wp-admin/maint/repair.php

Follow the steps to repair your broken database.

share|improve this answer

answered 3 hours ago

Jack Johansson♦

11.1k71440

add a comment | 

up vote
2
down vote

up vote
2
down vote

Uh oh, that's an important table. You might have lost a bunch of options, but you can still repair the database. WordPress allows a repair mode, which you can repair the database.

Open the wp-config.php file using FTP, and add this line before the ABSPATH:

define( 'WP_ALLOW_REPAIR', true );

now head over to :

http://yourdomain.com/wp-admin/maint/repair.php

Follow the steps to repair your broken database.

share|improve this answer

answered 3 hours ago

Jack Johansson♦

11.1k71440

Uh oh, that's an important table. You might have lost a bunch of options, but you can still repair the database. WordPress allows a repair mode, which you can repair the database.

Open the wp-config.php file using FTP, and add this line before the ABSPATH:

define( 'WP_ALLOW_REPAIR', true );

now head over to :

http://yourdomain.com/wp-admin/maint/repair.php

Follow the steps to repair your broken database.

share|improve this answer

answered 3 hours ago

Jack Johansson♦

11.1k71440

share|improve this answer

share|improve this answer

answered 3 hours ago

Jack Johansson♦

11.1k71440

answered 3 hours ago

Jack Johansson♦

11.1k71440

answered 3 hours ago

Jack Johansson♦

11.1k71440

11.1k71440

add a comment | 

add a comment | 

eepp is a new contributor. Be nice, and check out our Code of Conduct.

 

draft saved

draft discarded

eepp is a new contributor. Be nice, and check out our Code of Conduct.

eepp is a new contributor. Be nice, and check out our Code of Conduct.

eepp is a new contributor. Be nice, and check out our Code of Conduct.

 

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fwordpress.stackexchange.com%2fquestions%2f314993%2flost-the-wp-options-table-whats-the-best-way-to-restore-the-site%23new-answer', 'question_page');

);

Post as a guest

Name Email

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name Email

Name Email

Name

Email

Name Email

Name

Email