|
Contents
Index
<< Previous
Next >>
PDF
Replace
|
|
Menu: Extras / Replace
MySQL-Front offers a data Search&Replace function within whole databases. Depending on the applied search mask/criteria, data within the database can be replaced in part or as a whole.
Search&Replace requires significant resources if tables are large. The actual amounts vary depending on numerous different factors.
Search for:
| Old value / pattern for which to search
|
Replace with:
Search options:
| Case sensitive: Capital/small letters are not adjusted.
|
| Whole values: Only values completely matching the search pattern are considered.
|
| Regular expression: Search using regular expressions.
|
Backup:
| A table can be generated before synchronization. This table will be assigned the name of the respective table with the extension "_bak". Already existing copies with this extension are overwritten without warning.
|
| A backup copy is generated completely within the database. Creating backups can use significant resources of the database if tables are large.
|
Warning:
| Existing data are changed and cannot be restored during replacing.
|
| User or program errors are always a possibility.
|
| Data backups are therefore important and should be created frequently!
|
See also:
|
|
