Get first part of file, until 'splitword'
Find first occurence of 'splitword' in file:
grep -n "splitword" bigdumpfile.sql | head -1 | cut -d : -f 1
Result is: 86948
Save partial dump:
Find first occurence of 'splitword' in file:
grep -n "splitword" bigdumpfile.sql | head -1 | cut -d : -f 1
Result is: 86948
Save partial dump:
cd into the directory you want to check
find -type l -exec ls -l {} \;
SELECT a.nid, b.nid FROM node AS a , node AS b WHERE a.nid = 13 AND b.nid !=14 AND b.nid !=15 ORDER BY RAND() LIMIT 3
You need DNS to resolve locally ?
Option 1: edit your hosts file
sudo vim /etc/hosts
ZBsp: Collation in dump ändern
cat dumpname | sed s/CHARSET=utf8/CHARSET=utf8\ COLLATE=utf8_unicode_ci/ > new_dumpname
WEBFONT Flashtalk
Drupal Usergroup MUC 20.04.
// Tipps //
mysqldump -uUSER -pPASSWD --allow-keywords --opt DB | gzip > DB.sql.gz