Skip to main content
Share Your Experience: Take the 2024 Developer Survey
42 votes
Accepted

How to skip specific tables with drush sql-dump?

Dump all tables except the cache table and tables starting with cache_. drush sql-dump --skip-tables-list=cache,cache_* > dumpfile.sql Database structure only. No data at all. drush sql-dump --...
Francisco Luz's user avatar
7 votes
Accepted

Accidentally deleted sites/all/modules in Drupal 7

Assuming the backup files you have are the same as the ones that were deleted, that should be fine. You'll probably want to flush the cache but other than that there shouldn't be any problems in ...
Clive's user avatar
  • 167k
4 votes

How do I move a site to a new server?

It seems that you may forgot to move the vendor directory to the new location. Also you may need to run composer dump-autoload to update the autoloader with your new vendor's path. Though may be ...
d70rr3s's user avatar
  • 949
4 votes
Accepted

I can't backup my website on a shared server because memory runs out. What can I do?

According to this tutorial hostgator shared hosts can get ssh access so 2 of the solutions below assume ssh access ha been setup properly (the setup of ssh is beyond the scope of these forums) This ...
GiorgosK's user avatar
  • 8,473
4 votes
Accepted

Disabling backups after "drush up"

Yes, use the --no-backup option with your command. drush --no-backup up myproject If you're you're looking to make this a default option, you can do something like Bash aliasing and just run that ...
Shawn Conn's user avatar
  • 26.9k
3 votes

Why does nothing change when I attempt to restore a backup?

This sounds like a bug of Backup and Migrate module, since file_directory_path() no longer exists in Drupal 7. So instead of file_directory_path() you should use: ...
kenorb's user avatar
  • 14.2k
3 votes

"Drush sqlc < myfile.sql" doesn't return the site to previously working state. Are there files to be deleted?

All drush sqlc does is apply the mysqldump to your database. If the target has tables that are not known of by the source those tables will not be dropped by the dump file before being replaced. You ...
Darvanen's user avatar
  • 4,083
3 votes
Accepted

"Drush sqlc < myfile.sql" doesn't return the site to previously working state. Are there files to be deleted?

The website encountered an unexpected error. Please try again later. There was an error on PHP that Drupal couldn't handle. If you have your install set to log errors, check the report. Another ...
rovr138's user avatar
  • 1,018
2 votes

HTTP error 500 when backup entire site

This is your error: General error: 2006 MySQL server has gone away You can try to fix this in two ways: my.ini Open your my.ini file and locate max_allowed_packet. By default this is 1M. Setting ...
Wim Mostrey's user avatar
  • 2,827
2 votes

Recover a deleted user's content

It depends on how complicated your content/site structure is, authored by the user account that got deleted, but it can be fairly easy if it's just nodes and sum such content. Use which ever ...
prkos's user avatar
  • 7,141
2 votes

Is there a token for the cron token?

The cron key is generated by Drupal core then stored as state data (system.cron_key) when Drupal is first installed. system_token_info() doesn't expose this key as a token. You could just make a ...
Shawn Conn's user avatar
  • 26.9k
1 vote
Accepted

Backup files very different size

The only real way to know why they are different sizes is to decompress the files and compare them. If the backups all restore correctly, the difference is that you are probably backing up the cache ...
Patrick Kenny's user avatar
1 vote
Accepted

Can't restore existing site (no route found for "GET /")

After restoration the database you need to reload cache. If drush is installed globally you can do it by executing this command from docroot drush cr . If drush is installed locally ../vendor/bin/...
miststudent2011's user avatar
1 vote

Why does my admin page appear corrupted after using Backup and Migrate?

If you forget to preserve the file permissions when restoring a backup, you'll run into this. Make sure you use tar's p flag when you extract the backup file. Run drush ws to see watchdog error logs ...
glenviewjeff's user avatar
1 vote
Accepted

Error opening socket ssl://api.nodesquirrel.com:443

https://www.drupal.org/project/backup_migrate/issues/3037038 Update April 10: Workaround Per e5sego, the "nodesquirrel_default_endpoint_urls" variable can be changed to "74.121.199.90/...
SemasPing's user avatar
1 vote
Accepted

Migration after server crash: maintenance mode and/or cache problem

Here is finally how I solved the problem with Yogesh help: when I tried to access the admin section while logged in as an administrator, I got an error. I therefore checked the watchdog table. The ...
MBR's user avatar
  • 111
1 vote

Work around to getting Backup and Migrate to work with Acquia Dev Cloud?

Correction : The install of Backup And Migrate works. Follow the procedure explained before to enable ssh access. Once logged in, do cd ~/dev/livedev/docroot Then drush -y en backup_migrate That'...
jmary's user avatar
  • 256
1 vote

Work around to getting Backup and Migrate to work with Acquia Dev Cloud?

The best is enable your access to the command line to their server. For this you need to store your public ssh_key in your profile on their platform. Then to find the exact server and username to ...
jmary's user avatar
  • 256
1 vote
Accepted

extracting data from specific content type

You can create a custom migration for that node type - see https://www.drupaleasy.com/blogs/ultimike/2016/04/drupal-6-drupal-81x-custom-content-migration (more than you need for just the one migration,...
Mike Ryan's user avatar
  • 1,333
1 vote
Accepted

what is the use of Backup Folder?

No, the database does not update your dump-file afterwards. You should prepare your new site with a database dump. Then when you are ready to move the site finally you should put your original site ...
Lars Nielsen's user avatar
1 vote

HTTP error 500 when backup entire site

You are most likely hitting a resource limit. Enable PHP error logging in the index.php file so you can get an error output. But most likely it's a memory issue or a timeout issue which you will need ...
Travis Johnston's user avatar
1 vote

How can I roll the database back to the backup

You can use Drush. All you need to do is to run, inside a Drupal instalation, the following command: drush sqlc < path/to/backup.sql *You may want to drop your current database before that. The ...
Luiz Henrique Guerra's user avatar
1 vote
Accepted

Cannot login after moving site

In your new machine you probably installed Apache and did not enable a2enmod rewrite To enable it, copy and paste the following line to your command line: sudo a2enmod rewrite && sudo ...
No Sssweat's user avatar
  • 31.3k
1 vote
Accepted

How to move whole Drupal website on USB for localhost use using XAMPP?

If you are married to the idea of running your website via a USB Drive, you can always just download a lamp stack to your computer and configure it to look at usb drive as it's default home directory. ...
J.Floyd's user avatar
  • 139
1 vote

Exporting nodes except for specific fields

Use feeds -> https://www.drupal.org/project/feeds for custom export / import of nodes, users, taxonomy terms or simple database records
AlexB's user avatar
  • 108
1 vote

How to migrate joomla users mysql file to drupal users. I have only MySQL database backup. I don't have files

Install your backup into a MySQl database, and use the Migrate module (http://dgo.to/migrate) to migrate your users into Drupal.
Jaypan's user avatar
  • 17.6k
1 vote
Accepted

Is it possible to backup created block as a module?

Exporting and importing blocks in Drupal 8 are quite easy (thanks to new configuration system). You don't need to create a module for this. In Drupal 8 configuration is stored in yml files. You can ...
ya.teck's user avatar
  • 5,642
1 vote

Prod CentOS core-only site work fine but local Ubuntu backup has no css loaded

Did you try the 777 recursively inside the files folder? (so it applies on files/css and files/js subfolders) Also I would check if SELinux is enabled on your CentOS server to discard you downloaded ...
Juan De León's user avatar
1 vote

Why does nothing change when I attempt to restore a backup?

Depending on your version of the Backup Migrate module you may have this bug https://www.drupal.org/node/2618516 - try upgrading the Backup Migrate module and see if you can then restore. Don't ...
George's user avatar
  • 558
1 vote

When I create a backup of a site, which directories and files should I include?

The key directories are modules, themes, and profiles. You also want to backup all settings.php files, and uploaded files as well. Although, I would separate the two into two backup files, since, ...
Kevin's user avatar
  • 27.9k

Only top scored, non community-wiki answers of a minimum length are eligible