Import Users

In general, the Feeds module might be a solution. I've not used the BackdropCMS port for feeds yet, but that is probably what I would have used for Drupal 7. https://backdropcms.org/project/feeds

If you are moving from a Drupal 7 site, you can run the Drupal 7 to BackdropCMS upgrade: https://backdropcms.org/upgrade-from-drupal

Please, provide a little more information. What kind of site are you importing users from? What is your experience level?

Don't import whole database, just users table. And 'profile', if u are using profile2 module on Your D7 install.

I had to move 90k users from drupal 7 to backdrop. I have a lot of fields in a profile form. I 've imported users and profile table, adjusted table format a bit (AFAIR) and imported all the fields like 'field_data_field_somename'. Later edited config files for the fields and uploaded by ftp.

If You have users only and no custom profiles, then import should go quite smoothly. Dump all of the users table except user id = 1 and import to users table on backdrop site.

What was the error in phpmyadmin? If it's timing out you can try export into multiple sql files and import them. Ultimately that's easier than trying to recreate the site.

Try using different engine or different charset. innoDB vs MyISAM, UTF8 vs UTF16.

ALTER TABLE my_table ENGINE = InnoDB;

But first look into the dump files and edit them accordingly. If there is something like

SET NAMES 'utf16'
SET CHARACTER SET utf16

Change it to utf8. And in general remove any unneccessary command which can result in import failure. I don't remember which one are these exactly, but something along the lines of:

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

These were nothing but a headache for me.

Also try INSERT IGNORE, when repeating partially successful import.

I decided to port the User Import module to make user imports simpler for Backdrop admins. It's still in very early stages but I'd love some help testing the various options if anyone is up to do some testing and file issues as they discover them (and PRs to fix would be amazing of course, but otherwise I'll try to tackle them as I can).

https://github.com/backdrop-contrib/user_import