You have destroyed a significant section of your database. Unless you have a backup you cannot get it back.
What happened when you changed the varchar to an int was that every entry not recognized as an integer was converted to 0. You can see that in your screenshot. That is not reversible. Data was lost.
In the future:
- Make a backup
- Don’t mess with things you don’t understand. Take the time to
understand first then mess with things.
Related Posts:
- Set Display Name to first and last name (phpmyadmin SQL Query)
- Can’t log into wordpress site – I have made a new user and still cant access
- Multiple developers / editors working on a site in progress
- How many users can WordPress handle?
- How to track user progress?
- Performance tips for a large user base [closed]
- Efficiency on displaying random authors based on large database
- Delete all post meta except featured image
- Extend the wp_users table
- How to use user table of a different database for WordPress users?
- Subscribers to posts
- Emojis getting converted to “?”
- How to replace values in WordPress DB using phpMyAdmin
- Select Multiple meta_value from WP DB; Single Query
- Getting all the users who have author privilege
- Delete all post meta except featured image Using SQL
- Accidentally deleted active_plugins portion of the wp_options DB table
- Does WordPress always create unique passwords?
- In what part of the WordPress core does the users table and usermeta table get joined?
- Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
- Modify Database in Multi-Site wp_usermeta table
- Users table association with users_metadata table appears broken
- Change WordPress prefix for only one table?
- WordPress database import: Row size too large
- wp_get_current_user always returns 0 continued
- Is there a smart way to obtain a list of only some selected user meta data?
- How can i customize the export personal data file?
- What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
- WordPress Database Huge wp_usermeta Table
- Import users from old WP site to new one
- How to Access wp_usermeta Data Immediately After a New User is Created
- Logins from WP users table use on another page
- MS Access to manage WordPress Database
- 2 WordPress sites with 2 databases but sharing the same users
- Connection refused on locahost after importing database?
- Convert user passwords to MD5?
- Changing root password in PHPMyAdmin for WordPress Database when going live
- Can’t update WordFence Options, clear data manually
- Does WordPress store the username as a primary key in the database?
- Is there a way to execute a php script outside WordPress?
- multiple wordpress installation with shared usertable on an different database
- Post Views / Hit Counter Problem?
- How to migrate a database from a server to another
- Best practice to import user base (subscribers) from one website to another?
- Share users across multiple sites on same database, but with different domains
- Users table missing from Database [closed]
- Some weird users in database
- How to delete a particular row in a database table
- Add search bar to Custom Database Table in WordPress Dashboard
- Recovering the table wp_usermeta from users
- How to direct my site to the proper URL without Dashboard
- SELECT SQL_CALC_FOUND_ROWS with wordpress search
- Regenerate user_nicename column
- Files on Localhost, Database on Server
- Backing up WordPress database and files
- Storing user submitted forms [closed]
- WordPress where clauses in db select
- wp_option table error while importing
- wp_insert_user not creating account correctly when ID is manually set
- Installing local to live WP into subdirectory
- Select From wpdb – Author/User Directory page
- Delete user with only subscriber role
- Need help with creating a searchable user data by name or specific number like ID
- Is there any way to monitor a MySQL db and check what has changed?
- DB prefix not updating
- Migrate Users From laravel to wordpress
- I wanted to Know that how can I give ingore to 0000-00-00 in my config file
- I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
- Display user data in numbered list
- User input to database
- I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
- how add more field to wp user and save it to database
- Move Non-WordPress users table to WordPress database
- Is there any defects for using same database prefix in WordPress for multiple sites?
- Migrating meta_key and meta_value from old theme to new one
- Change user_nickname for author page link
- What is recommended data type and encryption type for password in a database
- How to force set same page as homepage and blogpage in static page settings
- syntax error for changing user role from database
- how restrict user to give star ratings once for a post?
- Duplicate database to roll back theme & content changes
- WP website showing blank page after moving from subdomain to main domain
- create a table using user meta custom data
- How to get the id of recently registered user from database?
- How to save dropdown slection by a user in the DB
- How to get specific table by current user login
- How to retrieve user data based on role using SQL?
- update multiple user meta field based on another meta field
- WordPress character set issue
- Missing latest posts and options after DB migration via phpMyAdmin
- Hash user emails in database?
- Check if a database is well installed
- What WordPress file is saving new users to database
- Get id from database
- Options table – where does my values go?
- WordPress sync with phpbb
- import (migration) user database to wp-users
- Database question while Migrating from one domain to another on same WebHost [Bluehost]
- Import Excel (or csv) Table with user-data as subscribers to wordpress
- WP Multisite Users Not Linking