mysql无备份恢复-独立表空间

最新推荐文章于 2022-12-07 11:03:17 发布
最新推荐文章于 2022-12-07 11:03:17 发布
阅读量100 收藏
点赞数
文章标签： 数据库


创建恢复库

点击(此处)折叠或打开

  1. mysql> create database helpdb default charset utf8;
  2. Query OK, 1 row affected (0.01 sec)
创建恢复表

点击(此处)折叠或打开

  1. mysql>
  2. CREATE TABLE `newaccount` (
  3.   `id` int(11) NOT NULL AUTO_INCREMENT,
  4.   `username` varchar(50) DEFAULT NULL,
  5.   `userpwd` varchar(50) DEFAULT NULL,
  6.   `createtime` datetime DEFAULT NULL,
  7.   PRIMARY KEY (`id`)
  8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;




创建对应函数

点击(此处)折叠或打开

  1. DELIMITER $$
  2. USE `helpdb`$$
  3. DROP FUNCTION IF EXISTS `rand_string`$$
  4. CREATE DEFINER=`root`@`%` FUNCTION `rand_string`(n INT) RETURNS VARCHAR(255) CHARSET latin1
  5. BEGIN
  6.     DECLARE chars_str VARCHAR(100) DEFAULT 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
  7.     DECLARE return_str VARCHAR(255) DEFAULT '';
  8.     DECLARE i INT DEFAULT 0;
  9.     WHILE i < n DO
  10.         SET return_str = CONCAT(return_str,SUBSTRING(chars_str , FLOOR(1 + RAND()*62 ),1));
  11.         SET i = i +1;
  12.     END WHILE;
  13.     RETURN return_str;
  14.     END$$
  15. DELIMITER ;
创建存储过程

点击(此处)折叠或打开

  1. DELIMITER $$
  2. USE `helpdb` $$
  3. DROP PROCEDURE IF EXISTS `p_repeat` $$
  4. CREATE DEFINER = `root` @`%` PROCEDURE `p_repeat` ()
  5. BEGIN
  6.   DECLARE v INT ;
  7.   SET v = 0 ;
  8.   REPEAT
  9.     INSERT INTO newaccount
  10.     VALUES
  11.       (
  12.         NULL,
  13.         rand_string (5),
  14.         rand_string (15),
  15.         NOW()
  16.       ) ;
  17.     SET v = v + 1 ;
  18.     UNTIL v >= 1000
  19.   END REPEAT ;
  20. END $$
  21. DELIMITER ;
调用mysql存储过程插入数据

点击(此处)折叠或打开

  1. mysql> CALL p_repeat;
  2. Query OK, 1 row affected (1.62 sec)
  3. mysql> select count(*) from newaccount;
  4. +----------+
  5. | count(*) |
  6. +----------+
  7. | 1000 |
  8. +----------+

手动插入数据

点击(此处)折叠或打开

  1. mysql> insert into newaccount values(null,'netdata','pwdnetdata',now());
  2. Query OK, 1 row affected (0.00 sec)
  3. mysql> select * from newaccount where id=1001;
  4. +------+----------+------------+---------------------+
  5. | id | username | userpwd | createtime |
  6. +------+----------+------------+---------------------+
  7. | 1001 | netdata | pwdnetdata | 2017-11-12 01:37:52 |
  8. +------+----------+------------+---------------------+
  9. 1 row in set (0.00 sec)


删除表

点击(此处)折叠或打开

  1. mysql> drop table newaccount;
  2. Query OK, 0 rows affected (0.01 sec)

关闭库

点击(此处)折叠或打开

  1. [root@mysqltest-213-2 undrop-for-innodb-master]# /etc/init.d/mysql stop
  2. Shutting down MySQL.. SUCCESS!
  3. [root@mysqltest-213-2 undrop-for-innodb-master]#
  4. 1 row in set (0.00 sec)
  5. [root@mysqltest-213-2 undrop-for-innodb-master]# ./stream_parser -f /var/lib/mysql/ibdata1
  6. Opening file: /var/lib/mysql/ibdata1
  7. File information:
  8. ID of device containing file: 64768
  9. inode number: 393238
  10. protection: 100660 (regular file)
  11. number of hard links: 1
  12. user ID of owner: 498
  13. group ID of owner: 500
  14. device ID (if special file): 0
  15. blocksize for filesystem I/O: 4096
  16. number of blocks allocated: 155648
  17. time of last access: 1510422066 Sun Nov 12 01:41:06 2017
  18. time of last modification: 1510422066 Sun Nov 12 01:41:06 2017
  19. time of last status change: 1510422066 Sun Nov 12 01:41:06 2017
  20. total size, in bytes: 79691776 (76.000 MiB)
  21. Size to process: 79691776 (76.000 MiB)
  22. Worker(0): 21.03% done. 2017-11-12 01:41:49 ETA(in 00:00:07). Processing speed: 7.984 MiB/sec


All workers finished in 1 sec
解析数据文件，得到table_id=228

点击(此处)折叠或打开

  1. [root@mysqltest-213-2 undrop-for-innodb-master]# ./c_parser -4Df pages-ibdata1/FIL_PAGE_INDEX/0000000000000001.page -t dictionary/SYS_TABLES.sql |grep newaccount
  2. 00000007A50E 030000024B0D54 SYS_TABLES "helpdb/newaccount" 71 4 1 0 80 "" 57
  3. 00000007A50E 030000024B0D54 SYS_TABLES "helpdb/newaccount" 71 4 1 0 80 "" 57
  4. SET FOREIGN_KEY_CHECKS=0;
  5. LOAD DATA LOCAL INFILE '/usr/local/tools/undrop-for-innodb-master/dumps/default/SYS_TABLES' REPLACE INTO TABLE `SYS_TABLES` FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES STARTING BY 'SYS_TABLES\t' (`NAME`, `ID`, `N_COLS`, `TYPE`, `MIX_ID`, `MIX_LEN`, `CLUSTER_NAME`, `SPACE`);
根据table_id得到index_id，index_id对应恢复数据文件

点击(此处)折叠或打开

  1. [root@mysqltest-213-2 undrop-for-innodb-master]# ./c_parser -4Df pages-ibdata1/FIL_PAGE_INDEX/0000000000000003.page -t dictionary/SYS_INDEXES.sql |grep 71
  2. SET FOREIGN_KEY_CHECKS=0;
  3. LOAD DATA LOCAL INFILE '/usr/local/tools/undrop-for-innodb-master/dumps/default/SYS_INDEXES' REPLACE INTO TABLE `SYS_INDEXES` FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES STARTING BY 'SYS_INDEXES\t' (`TABLE_ID`, `ID`, `NAME`, `N_FIELDS`, `TYPE`, `SPACE`, `PAGE_NO`);
  4. 00000007A50E 030000024B0BFF SYS_INDEXES 71 74 "PRIMARY" 1 3 57 4294967295
  5. 00000007A50E 030000024B0BFF SYS_INDEXES 71 74 "PRIMARY" 1 3 57 4294967295
注意这里还要扫描逻辑卷一遍跟共享表空间恢复不一样的地方

点击(此处)折叠或打开

  1. [root@mysqltest-213-2 undrop-for-innodb-master]# ./stream_parser -f /dev/mapper/vg_mysqltest2132-lv_root -t 18G
  2. Opening file: /dev/mapper/vg_mysqltest2132-lv_root
  3. File information:
  4. ID of device containing file: 5
  5. inode number: 6976
  6. protection: 60660 (block device)
  7. number of hard links: 1
  8. user ID of owner: 0
  9. group ID of owner: 6
  10. device ID (if special file): 64768
  11. blocksize for filesystem I/O: 4096
  12. number of blocks allocated: 0
  13. time of last access: 1510407590 Sat Nov 11 21:39:50 2017
  14. time of last modification: 1510407590 Sat Nov 11 21:39:50 2017
  15. time of last status change: 1510407590 Sat Nov 11 21:39:50 2017
  16. total size, in bytes: 0 (0.000 exp(+0))
  19. Size to process: 19327352832 (18.000 GiB)
  20. Worker(0): 1.08% done. 2017-11-12 01:46:39 ETA(in 00:03:10). Processing speed: 95.945 MiB/sec
  21. Worker(0): 2.12% done. 2017-11-12 01:48:14 ETA(in 00:04:42). Processing speed: 63.880 MiB/sec
  22. Worker(0): 3.16% done. 2017-11-12 01:54:30 ETA(in 00:10:51). Processing speed: 27.377 MiB/sec
  23. Worker(0): 4.20% done. 2017-11-12 01:46:45 ETA(in 00:03:04). Processing speed: 95.844 MiB/sec
  24. Worker(0): 5.24% done. 2017-11-12 01:46:45 ETA(in 00:03:02). Processing speed: 95.820 MiB/sec
  25. Worker(0): 6.28% done. 2017-11-12 01:48:16 ETA(in 00:04:30). Processing speed: 63.880 MiB/sec
  26. Worker(0): 7.32% done. 2017-11-12 01:48:16 ETA(in 00:04:27). Processing speed: 63.896 MiB/sec
  27. Worker(0): 8.36% done. 2017-11-12 01:46:47 ETA(in 00:02:56). Processing speed: 95.828 MiB/sec
  28. Worker(0): 9.40% done. 2017-11-12 01:46:47 ETA(in 00:02:54). Processing speed: 95.906 MiB/sec
  29. Worker(0): 10.44% done. 2017-11-12 01:46:47 ETA(in 00:02:52). Processing speed: 95.891 MiB/sec
  30. Worker(0): 11.49% done. 2017-11-12 01:45:20 ETA(in 00:01:24). Processing speed: 192.000 MiB/sec
  31. Worker(0): 12.53% done. 2017-11-12 01:46:46 ETA(in 00:02:48). Processing speed: 95.883 MiB/sec
  32. Worker(0): 13.57% done. 2017-11-12 01:45:22 ETA(in 00:01:23). Processing speed: 191.938 MiB/sec
  33. Worker(0): 15.09% done. 2017-11-12 01:44:55 ETA(in 00:00:55). Processing speed: 280.000 MiB/sec
  34. Worker(0): 17.13% done. 2017-11-12 01:44:41 ETA(in 00:00:40). Processing speed: 376.000 MiB/sec
  35. Worker(0): 19.04% done. 2017-11-12 01:44:44 ETA(in 00:00:42). Processing speed: 352.000 MiB/sec
  36. Worker(0): 20.99% done. 2017-11-12 01:44:43 ETA(in 00:00:40). Processing speed: 360.000 MiB/sec
  37. Worker(0): 22.90% done. 2017-11-12 01:44:44 ETA(in 00:00:40). Processing speed: 352.000 MiB/sec
  38. Worker(0): 24.81% done. 2017-11-12 01:44:44 ETA(in 00:00:39). Processing speed: 352.000 MiB/sec
  39. Worker(0): 26.46% done. 2017-11-12 01:44:50 ETA(in 00:00:44). Processing speed: 304.000 MiB/sec
  40. Worker(0): 28.54% done. 2017-11-12 01:44:41 ETA(in 00:00:34). Processing speed: 384.000 MiB/sec
  41. Worker(0): 30.54% done. 2017-11-12 01:44:42 ETA(in 00:00:34). Processing speed: 368.000 MiB/sec
  42. Worker(0): 32.45% done. 2017-11-12 01:44:44 ETA(in 00:00:35). Processing speed: 352.000 MiB/sec
  43. Worker(0): 34.05% done. 2017-11-12 01:44:51 ETA(in 00:00:41). Processing speed: 296.000 MiB/sec
  44. Worker(0): 35.49% done. 2017-11-12 01:44:56 ETA(in 00:00:45). Processing speed: 263.930 MiB/sec
  45. Worker(0): 37.44% done. 2017-11-12 01:44:44 ETA(in 00:00:32). Processing speed: 360.000 MiB/sec
  46. Worker(0): 39.39% done. 2017-11-12 01:44:44 ETA(in 00:00:31). Processing speed: 360.000 MiB/sec
  47. Worker(0): 40.95% done. 2017-11-12 01:44:51 ETA(in 00:00:37). Processing speed: 288.000 MiB/sec
  48. Worker(0): 42.95% done. 2017-11-12 01:44:43 ETA(in 00:00:28). Processing speed: 368.000 MiB/sec
  49. Worker(0): 44.86% done. 2017-11-12 01:44:44 ETA(in 00:00:28). Processing speed: 352.000 MiB/sec
  50. Worker(0): 45.90% done. 2017-11-12 01:45:09 ETA(in 00:00:52). Processing speed: 191.750 MiB/sec
  51. Worker(0): 46.94% done. 2017-11-12 01:45:08 ETA(in 00:00:50). Processing speed: 192.000 MiB/sec
  52. Worker(0): 48.90% done. 2017-11-12 01:44:45 ETA(in 00:00:26). Processing speed: 360.000 MiB/sec
  53. Worker(0): 50.89% done. 2017-11-12 01:44:44 ETA(in 00:00:24). Processing speed: 368.000 MiB/sec
  54. Worker(0): 52.80% done. 2017-11-12 01:44:45 ETA(in 00:00:24). Processing speed: 352.000 MiB/sec
  55. Worker(0): 54.71% done. 2017-11-12 01:44:45 ETA(in 00:00:23). Processing speed: 352.000 MiB/sec
  56. Worker(0): 56.27% done. 2017-11-12 01:44:50 ETA(in 00:00:27). Processing speed: 288.000 MiB/sec
  57. Worker(0): 57.66% done. 2017-11-12 01:44:54 ETA(in 00:00:30). Processing speed: 255.937 MiB/sec
  58. Worker(0): 59.70% done. 2017-11-12 01:44:44 ETA(in 00:00:19). Processing speed: 376.000 MiB/sec
  59. Worker(0): 61.66% done. 2017-11-12 01:44:45 ETA(in 00:00:19). Processing speed: 360.000 MiB/sec
  60. Worker(0): 63.61% done. 2017-11-12 01:44:45 ETA(in 00:00:18). Processing speed: 360.000 MiB/sec
  61. Worker(0): 65.69% done. 2017-11-12 01:44:44 ETA(in 00:00:16). Processing speed: 384.000 MiB/sec
  62. Worker(0): 67.34% done. 2017-11-12 01:44:48 ETA(in 00:00:19). Processing speed: 304.000 MiB/sec
  63. Worker(0): 68.38% done. 2017-11-12 01:45:00 ETA(in 00:00:30). Processing speed: 191.922 MiB/sec
  64. Worker(0): 69.95% done. 2017-11-12 01:44:50 ETA(in 00:00:19). Processing speed: 288.000 MiB/sec
  65. Worker(0): 71.94% done. 2017-11-12 01:44:46 ETA(in 00:00:14). Processing speed: 368.000 MiB/sec
  66. Worker(0): 73.98% done. 2017-11-12 01:44:45 ETA(in 00:00:12). Processing speed: 376.000 MiB/sec
  67. Worker(0): 76.02% done. 2017-11-12 01:44:45 ETA(in 00:00:11). Processing speed: 376.000 MiB/sec
  68. Worker(0): 77.76% done. 2017-11-12 01:44:47 ETA(in 00:00:12). Processing speed: 320.000 MiB/sec
  69. Worker(0): 78.80% done. 2017-11-12 01:44:56 ETA(in 00:00:20). Processing speed: 191.891 MiB/sec
  70. Worker(0): 79.84% done. 2017-11-12 01:45:16 ETA(in 00:00:38). Processing speed: 95.813 MiB/sec
  71. Worker(0): 80.88% done. 2017-11-12 01:44:57 ETA(in 00:00:18). Processing speed: 191.891 MiB/sec
  72. Worker(0): 81.92% done. 2017-11-12 01:44:57 ETA(in 00:00:17). Processing speed: 192.000 MiB/sec
  73. Worker(0): 83.31% done. 2017-11-12 01:44:53 ETA(in 00:00:12). Processing speed: 256.000 MiB/sec
  74. Worker(0): 85.35% done. 2017-11-12 01:44:49 ETA(in 00:00:07). Processing speed: 376.000 MiB/sec
  75. Worker(0): 86.91% done. 2017-11-12 01:44:51 ETA(in 00:00:08). Processing speed: 288.000 MiB/sec
  76. Worker(0): 88.69% done. 2017-11-12 01:44:50 ETA(in 00:00:06). Processing speed: 328.000 MiB/sec
  77. Worker(0): 89.73% done. 2017-11-12 01:44:54 ETA(in 00:00:09). Processing speed: 191.939 MiB/sec
  78. Worker(0): 90.77% done. 2017-11-12 01:44:54 ETA(in 00:00:08). Processing speed: 191.883 MiB/sec
  79. Worker(0): 92.51% done. 2017-11-12 01:44:51 ETA(in 00:00:04). Processing speed: 320.000 MiB/sec
  80. Worker(0): 93.55% done. 2017-11-12 01:44:54 ETA(in 00:00:06). Processing speed: 192.000 MiB/sec
  81. Worker(0): 95.29% done. 2017-11-12 01:44:51 ETA(in 00:00:02). Processing speed: 320.000 MiB/sec
  82. Worker(0): 97.11% done. 2017-11-12 01:44:51 ETA(in 00:00:01). Processing speed: 336.000 MiB/sec
  83. All workers finished in 83 sec



查看对应数据页文件

点击(此处)折叠或打开

  1. [root@mysqltest-213-2 undrop-for-innodb-master]# ls pages-vg_mysqltest2132-lv_root/FIL_PAGE_INDEX/0000000000000074.page
  2. pages-vg_mysqltest2132-lv_root/FIL_PAGE_INDEX/0000000000000074.page

恢复表结构

点击(此处)折叠或打开

  1. [root@mysqltest-213-2 undrop-for-innodb-master]# cat newaccount.sql
  2. CREATE TABLE `newaccount` (
  3.   `id` int(11) NOT NULL AUTO_INCREMENT,
  4.   `username` varchar(50) DEFAULT NULL,
  5.   `userpwd` varchar(50) DEFAULT NULL,
  6.   `createtime` datetime DEFAULT NULL,
  7.   PRIMARY KEY (`id`)
  8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
抽取数据

点击(此处)折叠或打开

  1. [root@mysqltest-213-2 undrop-for-innodb-master]# ./c_parser -6f pages-ibdata1/FIL_PAGE_INDEX/0000000000000074.page -t newaccount.sql | head -5
  2. -- Page id: 5, Format: COMPACT, Records list: Valid, Expected records: (301 301)
  3. 00000007A1B5 AC0000015F0110 newaccount 151 "0GdUH" "DTo9njhkAO9adoc" "2017-11-12 01:36:10.0"
  4. 00000007A1B6 AD000001600110 newaccount 152 "CoT8Q" "DtjZQ4Iaz9UVKOD" "2017-11-12 01:36:10.0"
  5. 00000007A1B7 AE000001610110 newaccount 153 "CZWzT" "z1f1aEyGzEnLzo7" "2017-11-12 01:36:10.0"
  6. 00000007A1B8 AF000001620110 newaccount 154 "eEpWh" "p50DYNW9J41Hkkv" "2017-11-12 01:36:10.0"



恢复数据
抽取数据转换成文件

点击(此处)折叠或打开

  1. [root@mysqltest-213-2 undrop-for-innodb-master]# ./c_parser -6f pages-vg_mysqltest2132-lv_root/FIL_PAGE_INDEX/0000000000000074.page -t newaccount.sql -o dumps/default/newaccount.dump -l dumps/default/newaccount.sql
  2. [root@mysqltest-213-2 undrop-for-innodb-master]# ls -alh dumps/default/newaccount.*
  3. -rw-r--r--. 1 root root 92K Nov 12 01:48 dumps/default/newaccount.dump
  4. -rw-r--r--. 1 root root 244 Nov 12 01:48 dumps/default/newaccount.sql
恢复数据

点击(此处)折叠或打开

  1. mysql> source dumps/default/newaccount.sql;
  2. Query OK, 0 rows affected (0.00 sec)
  3. Query OK, 6002 rows affected (0.06 sec)
  4. Records: 6002 Deleted: 0 Skipped: 0 Warnings: 0
  5. mysql> select count(*) from newaccount;
  6. +----------+
  7. | count(*) |
  8. +----------+
  9. | 1001 |
  10. +----------+
  11. 1 row in set (0.00 sec)
  12. mysql> checksum table newaccount;
  13. +-------------------+------------+
  14. | Table | Checksum |
  15. +-------------------+------------+
  16. | helpdb.newaccount | 2512700176 |
  17. +-------------------+------------+
  18. 1 row in set (0.03 sec)



参阅文档https://twindb.com/recover-after-drop-table-innodb_file_per_table-is-on/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24486203/viewspace-2147148/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24486203/viewspace-2147148/

cuanshao4773
关注
mysql无备份恢复
weixin_34067980的博客
03-27 2563
环境： centos 7.4+ mysql 5.7.19 在无备份的情况下数据库损坏时，可以从磁盘文件中恢复出数据，不一定百分百成功，使用的工具是undrop-for-innodb-master.zip 一，从frm恢复表结构（使用mysql-utilities工具） 1，安装mysql-utilities #yum localinstall mysql...
mysql 5.6 使用传输表空间迁移表或恢复误删除的表
lidan3959的专栏
05-06 2687
mysql 5.6 使用传输表空间的方式恢复误删除的表 一，简单说明： 1），传输表空间的限制：   1，mysql 版本 5.6.6 及其以上，并且版本建议源和目标版本建议都是GA版并且大版本一样   2，表引擎为innodb并且开启独立表空间  innodb_file_per_table   3，处于导出状态的表只允许读也即是”read_only“状态   4，DI
【黄啊码】MySQL入门—17、在没有备份的情况下，如何恢复数据库数据？
黄啊码
10-30 2090
在没有备份的情况下，如何恢复mysql数据库数据？
记一次MySQL数据库恢复（附方案）
欢迎关注公众号：【码农突围】，公号后台回复9999，可以获取一份500页的LeetCode刷题笔记。
01-04 693
恢复步骤概要 备份frm、ibd文件 如果mysql版本发生变化，安装回原本的mysql版本 创建和原本库名一致新库，字符集都要保持一样 通过frm获取到原先的表结构，通过的得到的表结构创建一个和原先结构一样的空表。 使用“ALTER TABLE DISCARD TABLESPACE;”命令卸载掉表空间 将原先的ibd拷贝到mysql的仓库下 添加用户权限 “chown . .ibd”,如果是操作和mysql的使用权限一致可以跳过 通过“ALTER TABLE IMPORT TABLESPACE;”命令恢
Mysql数据库备份恢复测试报告-mysqldump.docx
最新发布
03-29
MySQL数据库的备份与恢复是确保数据安全性的重要环节。在本次测试中，主要验证了全量备份和增量备份的恢复功能，以及数据恢复后的时间一致性。以下是详细的测试过程和相关知识点： 1. **全量备份与增量备份**： ...
MySQL 备份与恢复 手把手教学视频
08-05
本教程将围绕“MySQL备份与恢复”这一主题，详细讲解如何保护你的宝贵数据，确保在出现故障时能够迅速恢复。 1. **备份的重要性**：数据丢失可能由于硬件故障、软件错误、人为操作失误或恶意攻击等多种原因造成。...
MySQL InnoDB表空间判断与独立表空间详解
理解InnoDB的表空间机制对数据库的管理和维护至关重要，尤其是在考虑数据备份、恢复、优化和资源隔离时。通过调整`innodb_file_per_table`参数，可以根据实际需求在性能、灵活性和存储管理之间找到平衡。例如，如果...
浅谈MySQL数据库的备份与恢复
09-09
MySQL数据库的备份与恢复是数据库管理系统中至关重要的环节，它涉及到数据安全性、系统稳定性和灾难恢复能力。在本文中，我们将深入探讨MySQL的几种备份方式、物理数据文件结构以及如何使用`mysqldump`进行备份和...
mysql编程 自定义函数 存储函数
Fouy_风度玉门。
12-11 1195
================================ = SQL编程       = ================================ 【结束符】 ； \g \G 【变量】：1、系统变量 2、用户自定义变量 //  变量的有效范围是，从连接建立到断开。 ★ 系统变量：查看系统变量( show variables) ★ 自定变量：set 变量
mysql 索引
沉梦昂志
11-20 239
基本介绍 索引的价值，在于提高一个海量表的检索速度，索引的算法有btree 二叉树的算法，还有一种就是hash算法 索引的分类 主键索引 (primary key)，唯一索引(unique)，普通索引(index)，全文索引(fulltext) ...
mysql begin end 定界符_mysql存储过程:delimiter定界符导致You have an error in your SQL syntax; check the manual t...
weixin_42313675的博客
02-17 584
执行如下存储过程：CREATEFUNCTION`rand_string`(nINT)RETURNSvarchar(255)CHARSETlatin1BEGINDECLAREchars_strvarchar(100)DEFAULT'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';DECLAREre...
【数据库数据恢复】MySQL数据库误删除未备份的数据恢复案例
beiya123的博客
12-07 2307
MySQL数据库数据恢复环境： 本地服务器，操作系统为windows server； 部署mysql单实例，引擎类型为innodb，表空间类型为独立表空间； 没有数据库备份，未开启binlog。 MySQL数据库故障： 用户使用Delete命令删除数据时未添加where子句进行筛选，导致全表数据被删除，删除后再未对该表做任何操作。
无备份情况下恢复MySQL误删的表，这样做再也不用怕误删了
热门推荐
u011277123的博客
09-18 4万+
小码农大世界 2017-09-14 21:52 上一篇文章聊了下session的基本原理，这两天想了下如何更好的了解session，及随着系统越来越大会碰到的问题。 这里我们假设服务器是一家公司，那么session就充当了看门大爷的角色。 用户想要进入我们的公司，我们总不能随随便便让人进入。这时候看门大爷就要求你记录的个人信息，来就是来访记录。然而用户可能办完一件事就走了，等下次
python 提取固定列名数据_python获取数据库列名
weixin_39806288的博客
12-01 6101
{"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":4,"count":4}]},"card":[{"des":"阿里云数据库专家保驾护航，为用户的数据库应用系统进行性能和风险评估，参与配合进行数据压测演练，提供数据库优化方面专业建议，在业务高峰期与用户共同保障数据库系统平...
空间mysql数据还原_mysql通过表空间来恢复或者传递数据
weixin_34634231的博客
01-19 442
mysql的备份工具通常有 mysqldump ,mysqlpump(5.7后新特性)等备份工具，这里我们可以尝试使用表空间进行传递方式是：拷贝数据文件+拷贝表空间 对应innodb引擎就是 ibd文件和cfg文件.cfg:该文件存储了表的数据字典信息执行此种方式的要求(1)需要使用独立表空间，开启innodb_file_per_table参数；(2)在做表导出时，该表只允许读不允许写；(3...
mysql没备份怎么恢复_mysql数据没有备份误删了怎么恢复
weixin_35600369的博客
01-25 3506
打开mysql的bin log功能：对于mysql也是支持增量备份，但要打开mysql的bin log功能。我们修改mysql的配置文件。linux是/etc/my.cnf，windows是mysql的安装目录/my.ini我们在[mysqld]下面加上log-bin一行代码，如下面。[mysqld]log-bin=mysql-bin复制代码加完后重起mysql即可。某客户更新数据的时候，误删了数...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值