WordPress database error: [Table './ay6u3nor6dat6ba1/kn6_ayu1n9k4_5_actionscheduler_actions' is marked as crashed and last (automatic?) repair failed]
SELECT a.action_id FROM kn6_ayu1n9k4_5_actionscheduler_actions a WHERE 1=1 AND a.hook='aioseo_send_usage_data' AND a.status IN ('in-progress') ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1

WordPress database error: [Table './ay6u3nor6dat6ba1/kn6_ayu1n9k4_5_actionscheduler_actions' is marked as crashed and last (automatic?) repair failed]
SELECT a.action_id FROM kn6_ayu1n9k4_5_actionscheduler_actions a WHERE 1=1 AND a.hook='aioseo_send_usage_data' AND a.status IN ('pending') ORDER BY a.scheduled_date_gmt ASC LIMIT 0, 1

Exporting data of postgresql database with pg_dump | Loop and Break

Exporting data of postgresql database with pg_dump

by · December 29, 2014

pg_dump — extract a PostgreSQL database into a script file or other archive file.

Example

E:\postgre\bin>pg_dump -U postgres -h localhost data2 > db.sql
Password:

E:\postgre\bin>

after executing first line, the system only asks for password of the user and the dump file will be created.

Where :
pg_dump : is the dump executable, found under bin directory of postgres installation
-U : Username
-h : localhost
data2 : name of the database to be exported
db.sql : name of the export file

Share

You may also like...

Categories